AnsweredAssumed Answered

relevant calculated fields are returning 0.00 when there is nothing to calculate and should be NULL

Question asked by LBerni@slco.org_slco on Aug 22, 2018
Latest reply on Jan 16, 2019 by LBerni@slco.org_slco

In the following screenshot, the fields 5 & 6 are calculated based on data in fields 1-4. The whole group (fields1-6) is relevant as to whether or not a sample is collected. But, when no sample is collected, the calculated fields are returning 0.00. I would like them to be blank. Is there a way to control (cancel) the calculation when the relevant expression is not met?