Hi,
Would like to know how to create a Formula with the following structure for a Line Item (1).
Closing Balance of Line Item (2) as of the end of the month, and this will show/happen only on the 10th of every month.
My attempt
END(Line Item (1) OFFSET( Closing Balance of Line Item (2), ?, ?)
Please advise,
Thank you
Solved! Go to Solution.
Here's are two ideas.
Here's are two ideas.
I'm going to try it.
Thank you
Hi,
I tried both of the formulas below and Anaplan accepted them, but I'm not getting back any values from my Formula for the 10th of every month.
IF NOT SYS01 Dates.10th of the Month? THEN end of period balance ELSE OFFSET(end of period balance,-10,end of period balance)
IF NOT 'S01 Time Settings'.'10th of every Month?' THEN 0 ELSE 'Securitization Master Acct (x5000 Closing)'[LOOKUP: 'S01 Time Settings'.End of the Month]
Thank you