Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago

GetData CVC function for rows

Hi All, Do we have a function to get data from a row within CV? For e.g. GetDataCell(CVC(Rental Revenue) / CVC(Fleet Actual))   I tried using this method but keep getting a syntax error....
Cube View
  • LeeB's avatar
    LeeB
    3 years ago

    Hi,


    Just spotted you are using Column math in a Row.

     

    You need:  GetDataCell(Divide(CVR(Rental Revenue), CVR(Fleet Actual)))

    Also, consider creating a member and writing a Dynamic calculation if this is a frequently used KPI.

     

    Lee

SandeepSingh's avatar
SandeepSingh
New Contributor
3 years ago

Hi

what i figured out is probably the problem was not in the syntax rather using a name "Variance"  as a column name. the moment i changed the column name from VarianceDollar to COL4 ..it started working. Not sure why but..atleast its working but still interested to know the root reason.