Forum Discussion

DiegoRomero's avatar
DiegoRomero
New Contributor II
2 years ago

CubeView: Dynamic prior quarter increase/decrease

Hi! I am trying to do the following variance to calculate the incremental balance between 2 Qtrs but the time filter doesn't work: GetDataCell(Variance(CVR(Row8),CVR(Row8):T#PovPrior1)):Name(Increm...
Cube View
Reports
DiegoRomero's avatar
DiegoRomero
New Contributor II
2 years ago

Thanks both, here is a screenshot of what I am trying to do. Tried to simplified further more, to just need to lag row 8 by 1 Qtr, essentially the End of Period of Q1 should be the Beginning of Period of the next one. Row8 is directly calculated within the cube view and can't be added to UD8 as it depends on a parameter the user sets up in the Cube view itself.