07-18-2022 06:13 AM
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?
07-18-2022 11:01 AM
Maybe you should use
Row 2: A#Penalties, A#Penalties.Children
OR do another row for A#Penalties.Children
07-19-2022 11:45 AM
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)