Forum Discussion

olivere91's avatar
olivere91
Helper I
5 years ago
Solved

IF Statement Formula Help

I'm writing a formula that I want to work like this: (item_inventory - sum of Quantity on SO) IF >20 then Drop in "In Stock", if <20 then Drop in "Out of Stock"

 

Here is my formula so far:

 

Inventory Status =
(SUM('items'[Inventory]) - SUM('Sales_Lines'[Quantity on SO]) )
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    You can use the below:
    Inventory Status = IF((SUM('items'[Inventory]) - SUM('Sales_Lines'[Quantity on SO]))>20,"In Stock","Out of Stock" )

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You can use the below:
    Inventory Status = IF((SUM('items'[Inventory]) - SUM('Sales_Lines'[Quantity on SO]))>20,"In Stock","Out of Stock" )