I was looking at this work around for calculating fields that may have possible null values, per this example that statement is within the calculations field, but I already have a calculation there summing total amounts from a repeat group. Would I still write this IF statement in the calculations field including the sum equation or would it also work in the constraints field? I copied the support document for the work around and a snap shot of the fields I need with this IF statement.
https://support.esri.com/en-us/knowledge-base/problem-the-total-value-is-not-calculated-if-any-input...
This is for the total acres of chemicals used for spraying weeds calculation:
This is for the total release in acres of biocontrol agents for weed control calculaiton"
These are the fields being calculated for the total acres being treated, summing total chemical acres + total biocontrol acres:
sum(${chemacres}) |
sum(${biosum_count}) |
Since not all of these will be used at once and I can't get the "Total Acres Treated" to calculate if any of these are null, (and can't count on field crews to remember to say '0') nor can I default these to 0 with the calculations being in the first two equation I mentioned about, I'm wanting to create the workaround for these null fields so the "Total Acres Treated" still calculates.
TIA