cancel
Showing results for 
Search instead for 
Did you mean: 

Cube View - Row/Column Intersection calculation using GetDataCell() and CVRC()

mccain1
New Contributor II

Looking for anyone who has used the CVRC() function successfully in their Cube Views.

If so, is there anything special you are doing with the syntax for the Row or Column Index #?

According to the OS documentation, I should be able to simply do this:  GetDataCell(CVRC(RowName,RowIndex,ColumnName,ColumnIndex).... ETC.)

Example:  GetDataCell(CVRC(MyRowA,1,MyColA,2) + CVRC(MyRowB,2,MyColD,4)

But even with the most basic test cube view, the result is always giving me an Invalid Index error.
Is there some special way to express the row or column Index # that I'm missing here?

Thanks in advance for any advice

1 REPLY 1

mccain1
New Contributor II

Please ignore - I discovered the issue and as it turns out, I managed to get this resolved using a different method.