I need help writing a formula...

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • In Progress
Hi all, I need some help writing an if/then formula... Basically, what I need it to do is, when I select an inventory item from a list, say IF (current, associated job set date) is BETWEEN (any other job set date and strike date) AND/OR (current job strike date) is BETWEEN (any other job set date and strike date) THEN show me the (total quantity of that inventory item owned) MINUS (total quantity of that inventory item proposed for any jobs matching the above date criteria), AND IF (current, associated job set date) IS NOT BETWEEN (any other job set date and strike date) AND (current, associated job strike date) IS NOT BETWEEN (any other job set date and strike date) THEN show me the (total quantity of that inventory item owned). 

Thank you in advance! I realize this is a pretty complex one, and I just don't know the QB code well enough to do this. 
Photo of Elena Larrabee

Elena Larrabee

  • 736 Points 500 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Esther

Esther

  • 702 Points 500 badge 2x thumb
Dear Elena , can you tell a little more;

Is there only one table involve in this Formula ?
Which are the fields in this table you want to use? [job],[set date], [strike date],[number of items],[owner]...so and so... .