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,

Can anyone help me please what i am doing wrong here. I want to use CVC where i want to divide Variancedollar by MTDBUDGET. Going by the above script its look like the syntax is correct but i am getting the Error.

Please help..Sandeep S