Line Item Final Shipping Amount INV01

[neg177]

Hi,

I need help on this line item formula. Below is the formula I came up with. Please advice.

IF NOT+Submit Purchase Order Request THEN 0 ELSE Suggested Order Amount for the Month NOT(Override Suggested Order Amount) THEN 0 ELSE Override Amount

Thank you 

[Puneeth H P]

Hi @neg177 

Above is not the correct format of using IF ELSE atleast here in this formula . 

It just says IF NOT Override Suggested Order Amount THEN Suggested Order Amount for the Month ELSE Override Amount

Thanks,

Puneeth HP 

[Sarthak]

Can you tell the logic behind this formula?

[ankit_cheeni]

Hi @neg177 

Your nesting of IF THEN ELSE isn't accurate. So Anaplan should ideally give a syntax error saying ".... the formula is invalid". First is to make that amend, something like this:

IF NOT Submit Purchase Order Request THEN 0 ELSE IF NOT(Override Suggested Order Amount) THEN Suggested Order Amount for the Month ELSE Override Amount

And I am thinking on your behalf but the intent is to close each IF with a THEN and an ELSE. Right now, your last THEN and ELSE isn't preceded by an IF. 

Hope this helps 🙂