Skip to main content
julia2
Newcomer
Jul 29, 2024 8:47 PM UTC

Issues Calculating Ratio using a financial and non-financial account: Revenue per Sales Day

Hi,

I'm wondering if anyone else has had a similar issue when creating DynamicCalc accounts that include a non-financial account member and a financial account member? I'm trying to create a revenue per day account that will use our A#SalesTot account and our A#IscSalDays account.  My formula is below:

Return api.Data.GetDataCell("Divide(A#SALESTOT, E#DRIVER:C#Local:S#Plan:A#ISCSALDAYS:F#EndBal:O#Top:I#None:U1#None:U2#Top_UD2)")

When I populate a cube view with each of these accounts separately, I get the correct data, but I can't figure out why the calculated account returns blank green cells.  Since I want to use the result in a dashboard chart, I can't use a column row math expression, which is how I calculate revenue per day in our other reports.

9 replies

Employee - Guide
TheJonGEmployee - Guide
Employee - Guide
Jul 29, 2024 11:57 PM UTC

Hi - there should not be any issues with dynamic calcs that include Non Financial account types. Multiplication of a Revenue/Expense/Flow and a Non Financial should work fine. Can you test if the E#DRIVER:C#Local:S#Plan:A#ISCSALDAYS:F#EndBal:O#Top:I#None:U1#None:U2#Top_UD2 part of your script is returning a value by adding a row to the Cube View and pasting in that script? If may be that that intersection is not returning data and it needs modified. 

julia2Author
Newcomer
Jul 30, 2024 2:53 PM UTC

Hi, I have a cube view with each of those accounts and the only one that doesn't return data is the calculated account.  

Employee - Guide
TheJonGEmployee - Guide
Employee - Guide
Jul 30, 2024 4:20 PM UTC

Maybe the value being returned is very small (since you are doing division). Can you right click one of the cells and click 'Cell Status' and see what the amount is? Otherwise, can you screenshot the Cube View and also screenshot the Cell POV Information of each of the accounts?

Terms & ConditionsAccessibility statement