Sum of accounts at base levels
I would like to return a sum of all rows in my cube view but using the 'sum of rows' is only returning the first result for every account under the main hierarchies I'm calling. This is the liter...
Forum Discussion
Hello,
If it's a KPI that users use frequently, I would create a KPI account with the Account Type and Formula Type set to "DynamicCalc". I would also try to use existing accounts for the calculation.
In the Formula field, you could write something like the following:
Return api.Data.GetDataCell("A#TotalAssets:F#CLO - A#TotalLiabilities:F#CLO - A#32000:F#OPE - A#TotalRevenue:F#None + A#TotalExpenses:F#None")Hope it helps!