This content has been marked as final. Show 2 replies
Amount always has a value but either Field 1 or Field 2 may be null, and if that's the case the total is null. It is fine when all three fields contain a value.
Have tried a number of things to get what seems a simple thing to work including changing options to insert '0' when null to no avail. :mad: