How would you correctly write an expression to return values, but ignore nulls? The problem I have run into is I have (field1*field2)+field3, but sometimes field2 can be empty/null. So until both field 1 and 2 have numbers, the calculated field doesn't return a value which is messing with various items I am trying to display.
I think this would be more of an "Excel" type structure with the IIF function, but am unsure.
I think this would be more of an "Excel" type structure with the IIF function, but am unsure.