GetData CVC function for rows

[Mustafa_A]

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

[LeeB]

Hi Mustafa,

Try:

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

Lee

[Mustafa_A]

Hi @LeeB 

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

[LeeB · Accepted solution]

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

[Mustafa_A]

Thank you!

It worked. However I agree with your idea of writing a dynamic calc. We plan to use in multiple reports. 

Thank you!

[SandeepSingh]

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]

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.