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. Any suggestions in the right directions will be appreciated.  Thanks!

 

Best,

Mustafa

 

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

  • LeeB's avatar
    LeeB
    Contributor II
    3 years ago

    Hi Mustafa,

    Try:

    GetDataCell(Divide(CVC(Col3), CVC(Col2))):Name(Ratio)

     

    Lee

     

    • Mustafa_A's avatar
      Mustafa_A
      Contributor II
      3 years ago

      Hi LeeB 

      I'm getting this error. Tried playing around with brackets and comma, but the error message still appears. 

       

       

       

       

       

       

      • LeeB's avatar
        LeeB
        Contributor II
        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

     

  • 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.