Level 2 Sprint 3 : AD02 Inventory Ordering Overrides

Options
AmalmMahmoudi
AmalmMahmoudi
in Modeling

Hello, I am inLevel 2 Sprint 3

I have the following formula for the boolean line items in AD02.

For the line : Override Amount - Write?

My formula is : IF 'INV01 Inventory Ordering'.Submit Purchase Order Request? AND 'INV01 Inventory Ordering'.Override Suggested Order Amount? THEN TRUE ELSE FALSE

Can anyone correcte my formula please ?

THANKS!!

Here is a screenshot of th formula hints and my formula

1.PNG
2.png
3.PNG

Best Answer

  • Tiffany.Rice
    Tiffany.Rice
    Answer ✓
    Options

    Can you share why you think the formula is incorrect? It appears to be working as intended where a user can only input an override amount if both conditions are met (submit purchase order & override suggested amount).

    The one tip I would give is that the IF/THEN conditions are redundant. You can simplify the formula to: 'INV01 Inventory Ordering'.Submit Purchase Order Request? AND 'INV01 Inventory Ordering'.Override Suggested Order Amount?

Answers

  • AmalmMahmoudi
    AmalmMahmoudi
    Options

    Hello Tiffany,

    The problem was fixed thank you , I didn't know that i can simplify the formula.

    Thanks

Categories