- OneStream Community
- Forums
- Reporting
- CVR function not working in Report and Excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
CVR function not working in Report and Excel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-25-2023 01:10 AM - edited 08-25-2023 10:05 AM
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
- Labels:
-
Cube View
-
Dashboards
-
Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-25-2023 02:37 AM
CVR formula looks good. Check the Error log, you may find more information on this error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 12:05 PM
Hello, did you find a solution to this problem? I am currently facing the same issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 01:59 PM
Hello Kashinath,
I would glad to hear from you if you found the solution. I got the same issue right now.
Regards
- Business rule didn't give results in Rules
- XFBR CubeViewHelpers passing dimension question in Reporting
- Restatements and Workflow implication in Workflow and Data Integration
- Custom FX Translation Not working for Rate type Periodic in Rules
- Combining data from 2 cubes to calculate Creditor days in Rules
