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!

  • Can you tell the logic behind this formula?

     

  • 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 🙂