10-30-2023 04:25 PM
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(Incremental RWA EOP)
Row 8 is also a CVR calculated row. I have Quarters in columns, so need to do the formula as dynamic as possible.
10-31-2023 08:00 AM
I think the first piece you should look at is where you have two calculated cells intersecting. You'll need to put an override on one of those.
10-31-2023 11:36 AM
Hi Aric, can you expand a little bit more?
11-01-2023 03:15 PM
It's a bit tough to understand what you're looking for without some screenshots, but here are some things to think about.
11-01-2023 04:13 PM
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.
11-01-2023 06:07 PM
Instead of trying to do it off of Row8, can you do it off Row7 with a different time period? That may be the easiest way. It's hard to know without seeing what is in Row7.