SUM qty field, but decrement from sum when new variable added?
Need guidance! I'm looking to sum a quantity column, but filter by 2 separate visuals. The difficulty I am having is decrementing the quantity when an added variable is introduced.
I'm looking for the quantity sum in WIP using the ASLY & TEST fields as my current filters. Below I can easily filter to get what quantity is in ASLY (qty 2 based on below), but when I add in a test date, the ASLY quantity doesn't decrement.
I am unsure how to include a statement to decrement? Thoughts?