wolfee
11 days agoNew Contributor
Error exporting Cube View to Excel/PDF when using CVRC
Hi,
I’ve created a cube view containing a Row Override GetDataCell CVRC formula that is throwing an error when exported to Excel or PDF. I believe it’s because I’m using CVRC which requires the use of an index which Excel/PDF don't know how to handle. I’ve tried simple GetDataCell formulas and they all export fine. I’ve read that this can happen when Excel doesn’t know how to handle the index but the formula doesn’t calculate without the index. Has anyone experienced this and how did you resolve it? Would it work if the calculation was done via business rule instead?
Below are screenshots from the desktop app and Excel, as well as the row override formula