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.
Hi, I have a cube view with each of those accounts and the only one that doesn't return data is the calculated account.
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?
Hi, these are the Cell POV's.
SalesDays: Stat account
Cb#CONSOL:E#DRIVER:P#?:C#Local:S#PLAN:T#2024M7:V#Periodic:A#ISCSALDAYS:F#EndBal:O#Top:I#None:U1#None:U2#TOP_UD2:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None
SalesPerDay: Calculated Account
Cb#CONSOL:E#EMI_US:P#?:C#USD:S#ACTUALS:T#2024M7:V#Periodic:A#Sales_By_SalesDays:F#EndBal_Tot:O#Top:I#Top:U1#TOP_UD1:U2#TOP_UD2:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None
Sales: Financial Account
Cb#CONSOL:E#EMI_US:P#?:C#USD:S#ACTUALS:T#2024M7:V#Periodic:A#SALESTOT:F#EndBal_Tot:O#Top:I#Top:U1#TOP_UD1:U2#TOP_UD2:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None
Only thing I can think of is that the account properties aren't set correctly. Is both AccountType and FormulaType set to DynamicCalc?
