I have 5 tables and in each table a field for the Year-To-Date Sales in numbers
I created a formula that will add up all the Year-To-Date Sales from all 5 tables.
The formula works if every table has the same record but if one table does not have one record then I get nothing back.
Here is the formula. Can someone help me to make this work?