Cube view check rows

Ioana
New Contributor III

Hello,

I have a question in regards to cube views - I have multiple rows in the report, some of them including member extensions, and I am gonna write here an example:

Row 1: A#Rent

Row 2: A#Penalties.Children

Row 3: A#OPEX

Check that I want to make: GetDataCell(CVR(Rent) + CVR(Penalties) - CVR(OPEX)):name(Check)

Instead of getting 0 on the check row, I get to have a difference due to tha fact that the formula only takes into consideration the first child of Penalties, ignoring the rest of the children.

How to accomodate/change the formula in order to have all the children into consideration?

 

Thank you,

Ioana

2 REPLIES 2

Sai_Maganti
Contributor II

Maybe you should use

Row 2: A#Penalties, A#Penalties.Children

OR do another row for A#Penalties.Children

Cosimo
Contributor II

 Hi Ioana,

Unless I'm missing something, just do the math with the 3 accounts in your Check row with a GetDataCell:

GetDataCell(A#Rent + A#Penalties - A#OPEX):name(Check)