Forum Discussion

wolfee's avatar
wolfee
New Contributor
11 days ago

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

 

 

No RepliesBe the first to reply