Forum Discussion

Kashinath's avatar
Kashinath
New Contributor II
2 years ago

CVR function not working in Report and Excel

Guys, We are using difference of  multiple CVR functions to get the value for a row, and it is working correctly in the Data Explorer , the data is also correct , but when we generate the report in PDF or Excel we are getting an error  in that cell with the name of the first row used in the CVR GetDataCell.

For eg: If "GetDataCell(CVR(A1)-CVR(A2)-CVR(A3)-CVR(A4))" is the function , then the error displayed in the cell in PDF and Excel is "Error : A1" .

Any idea why this is happening?

 

Thanks

Cube View
Dashboards
Reports

3 Replies

Sort By
  • AK's avatar
    AK
    New Contributor III
    2 years ago

    CVR formula looks good. Check the Error log, you may find more information on this error.

  • Scottvdl's avatar
    Scottvdl
    New Contributor
    2 years ago

    Hello, did you find a solution to this problem? I am currently facing the same issue. 

  • Oscarvelasquez's avatar
    Oscarvelasquez
    New Contributor II
    2 years ago

    Hello Kashinath,

    I would glad to hear from you if you found the solution. I got the same issue right now.

    Regards