s_cynthiia
5 hours agoNew Contributor II
CVR and GetDataCell Issue in cube views
Hello,
I currently have a cube where I am having an issue calculating variances.
The row has GetDataCell(CVR(Row1)+CVR(Row2)) and Column is has T#POV, T#POVPrior12, GetDatacell(T#Pov-T#POVPrior12).
When I run the report, the first two columns run correctly for T#POV and T#POVPriorYear, but the third column where the two get data cells meet does not calculate correctly. I can't get it to work on a column override either as I know there is a order of operation for the GetDataCell.
I want to keep the report as dynamic as possible, is there a way this can be achieved without breaking the columns out and manually doing the overrides?