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...
Forum Discussion
can you paste here the cell POV intersections for us to see? Did you try to add it this directly in the formulae?
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)