Forum Discussion

julia2's avatar
julia2
New Contributor II
6 months ago

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 revenu...
Reports
TheJonG's avatar
TheJonG
Contributor III

Only thing I can think of is that the account properties aren't set correctly. Is both AccountType and FormulaType set to DynamicCalc?

 

julia2's avatar
julia2
New Contributor II
6 months ago

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!

 

  • TheJonG's avatar
    TheJonG
    Contributor III
    6 months ago

    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.

     

    • julia2's avatar
      julia2
      New Contributor II
      6 months ago

      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?

       

      • KarlT's avatar
        KarlT
        Contributor III
        5 months ago

        Hi Julia,

        In Jon's formula the "api.logmessage" parts will write the values to the Error Log (under the System tab) - so after you open the cube view you can go to the error log and see what value is being recorded.

        Once you've resolved the issues you will need to make sure you remove the log message part of the code so you don't end up with lots of unnecessary entries.

        Regards