I am trying to subtract a numeric field in one query from a numeric field in another query.
The two queries are joined, with the first query being the primary. It contains more records than the 2nd query.
If there is no corresponding record in the 2nd query, the result is blank even if the 1st query contains a number.
For example, the 1st query has a record with a value of 100.
There is no corresponding record in the 2nd query.
The result is a blank cell rather than 100.
How do I get the math to work?
Thank you.