Hello,
I have a series of fields that calculate the number of days between two dates. The calculations work fine .. when there are two dates, it calculates the number of days... when there aren't two dates, it leaves the field blank.
But when I create a report, the blank fields are reflected as ZERO, which is throwing off aggregates.
I would like to reflect blank or NULL when there is no value calculated.
Thank you in advance.
First picture is of the form and the blank calculated fields.
Second picture is the report.