Forum Discussion
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: I...
You can use the below:
Inventory Status = IF((SUM('items'[Inventory]) - SUM('Sales_Lines'[Quantity on SO]))>20,"In Stock","Out of Stock" )
Thanks so much, that worked!