Forum Discussion

Spalomino's avatar
Spalomino
New Contributor II
2 years ago

datacalculate help

Dear Community: I am trying to add a previous year M12 balance to a SCF report.  I can't seem to get prior year data to come over.  However, If I code the amount it does work. ' api.Data.calcul...
Finance
NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago

Hi Spalomino 
The value you have of 62225, can  you see it in your cuve view? Did you right click on its cell and analysed the cell POV and all its intersection? Did you do the same for A#CF_RepaymentEquityInvestment?

  • Spalomino's avatar
    Spalomino
    New Contributor II
    2 years ago

    Nicolas:  Thanks for responding.  Yes, the data [$62,225] is sitting our cube.

    • NicolasArgente's avatar
      NicolasArgente
      Valued Contributor
      2 years ago

      can you paste here the cell POV intersections for us to see? Did you try to add it this directly in the formulae? 

      • Spalomino's avatar
        Spalomino
        New Contributor II
        2 years ago

        Cb#ABG_FinRptg:E#Praxis:P#?:C#Local:S#Actual:T#2023M9:V#YTD:A#CF_RepaymentEquityInvestment:F#StatementChange:O#Top:I#None:U1#CF_Load_BS:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None

        =XFGetCell(True, "ABG_FinRptg", "Praxis", "", "Local", "Actual", "2023M9", "YTD", "CF_RepaymentEquityInvestment", "StatementChange", "Top", "None", "CF_Load_BS", "None", "None", "None", "None", "None", "None", "None")

        XFCell(Cb#ABG_FinRptg:E#Praxis:C#Local:S#Actual:T#2023M9:V#YTD:A#CF_RepaymentEquityInvestment:F#StatementChange:O#Top:I#None:U1#CF_Load_BS:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None, Culture=User, NumberFormat=N0, DisplayNoDataAsZero=True, Scale=0, FlipSign=False, ShowPercentSign=False, UseApostrophePrefix=False)