Hello All,
Quick question re building an expression to calculate the value of a calculated column:
I have 4 columns: "Precipitation1", "Precipitation2", "Totalrainfall1", and "Totalrainfall2".
Totalrainfall2 is the calculated column of Precipitation1 + Precipitation2. If there is no value (i.e. blank cell) from adding Precipitation1 and Precipitation2, I want to use the value from Totalrainfall1 in Totalrainfall2. Any help with building this expression is much appreciated.
Cheers!