Forum Discussion

Ioana's avatar
Ioana
New Contributor III
3 years ago

Cube view check rows

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

Cube View
  • Cosimo's avatar
    Cosimo
    Contributor II
    3 years ago

     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)

  • Sai_Maganti's avatar
    Sai_Maganti
    Contributor II
    3 years ago

    Maybe you should use

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

    OR do another row for A#Penalties.Children