Report template issues

Hello,

I have a report template issue that is arising when I add in an "If" function. For calibration standards, QC checks, and System Suit, I have my concentration in ug/g, and for samples, I have a different concentration value that will be reported (pictures at the bottom). When entering the "value" into the report columns, if I use an "If" statement to filter out what I'm not reporting, I get many more decimal places than the 4 that I originally had when no "If" statement was there; it showed the same number of decimal places that were seen in "Data processing". Would someone have a solution to this? (A rounding function tacked along to the "If" function did not work).

Was this helpful?