Hi, I'm trying to replicate the Excel Formula in Anaplan below. I'm trying to use the AND function, so i made two Boolean Line Items and combined them to satisfy the condition. The formula worked but no numbers are showing in my line item. please advise. Excel Formula =IF(AND(Accounts!WP32<3000000,MIN(4000000,WP27,WP41-2000000)>0),MIN(4000000,WP27,WP41-2000000),0) My Formula IF 'EFS to WFA Calc1' AND 'EFS to WFA Calc 2' THEN MIN ( 4000000 , IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY ( START ( ) ) = 1 THEN OFFSET ( 'Y03 Securitization (Actuals)'.'Excess Funding Account (x1005)' , - 3 , 0 ) ELSE PREVIOUS ( 'Y03 Securitization (Actuals)'.'Excess Funding Account (x1005)' ) ELSE 0 , ( IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY ( START ( ) ) = 1 THEN OFFSET ( 'Y03 Securitization (Actuals)'.'Excess Collateral / (Deficit)' , - 3 , 0 ) ELSE PREVIOUS ( 'Y03 Securitization (Actuals)'.'Excess Collateral / (Deficit)' ) ELSE 0 ) - 2000000 ) ELSE 0
... View more