Hi,
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.
Excel Function
=IF(MIN(Securitization!$RW$33:$SP$33)<0,1,0)
Analpan Function
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
Thank you