IF Statement Formula Help

[olivere91]

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]) )

[olivere91]

Thanks so much, that worked! 

[Anonymous · Accepted solution]

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