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?
Hi, Yes It's so weird. I've triple checked it and I'm totally stuck. I can create it as a calculation in a cube view using the CVR calculation, but I want to put it in a dashboard. Thank you for your efforts!
The next thing I would try is to log both parts of the calc and see if you're getting data. Then you can at least narrow it down to which part is the issue.
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)")
Dim salesTot As String = api.Data.GetDataCell("A#SALESTOT").CellAmountAsText
Dim ISCSALDAYS As String = api.Data.GetDataCell("E#DRIVER:C#Local:S#Plan:A#ISCSALDAYS:F#EndBal:O#Top:I#None:U1#None:U2#Top_UD2").CellAmountAsText
api.logmessage($"Sales Tot Amount = {salesTot}
api.logmessage($"Sales Tot Amount = {ISCSALDAYS}From there you can tweak some of the members in the script until you get data.
Hi,
I copied in your formula and added the account to a cube view. I looked at the cell status. Is that what you meant by logging it to see if it returns data?