Line Item Final Shipping Amount INV01
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
Answers
-
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
Success is the Intersection of Dreams and Hardwork!
3 -
Can you tell the logic behind this formula?
0 -
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 🙂
5
