I'm trying to replicate this Excel Function in Anaplan. I want to make sure my Anaplan Function is picking up all the values for my Line Item from the begging through the end of the month, and not just the beginning and end month numbers. I have the Formulas below. Please advise.
IF MIN('Y03 Securitization'.'Securitization Master Acct (x5000 Closing)'[LOOKUP: 'S01 Time Settings'.Start of the Month], 'Y03 Securitization'.'Securitization Master Acct (x5000 Closing)'[LOOKUP: 'S01 Time Settings'.EOM Date]) < 0 THEN 1 ELSE 0
You may need to add a List that represents the Timescale you're aggregating over, with a mapping to the real Timescale in a module. Use MIN against this "fake time" list for values in the mapping module. Will then need to do a mapping lookup to get those values into your target...