Ignore item in If Statement that =0
I am trying to create an if statement that only counts an item if it meets the rquirements but this formula adds the item with a quantity of zero if it does not meet the requirements. In Excel, I would put “” in place of the zero, how can I do that in Stack?
(if([MeasuredLinear]>0,if([MeasuredLinear]<=12,([MeasuredLinear]/12),0)))*2
0
Comments
The formula on your Item only calculates how much of that Item you are selling. If that amount is calculated to be 0, then so be it. It's still going to show that Item in your Reports and Estimates because you have selected it to (potentially) sell to your customer.
Assuming that Item is in a Group, you can just not select it when you are making your decisions about what Items are involved with that specific Takeoff. If you select it to start with, and discover later it's not needed (Purchase Quantity = 0), you can always go edit your decisions on that Takeoff and set that Group to None eliminating that Item from the list.
Please sign in to leave a comment.