Forum Discussion

s_cynthiia's avatar
s_cynthiia
New Contributor II
5 hours ago

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?

No RepliesBe the first to reply