Can Max formula handle fields with blank values?
I have three number fields field a, field b, field c with default value as blank(default custom field setting)
Max(field a, field b, field c) is causing an internal salesforce error if I fill out field a and field c and try to save the record without field b. Strangely I can save the record by just filling out one of the three fields.
Is this because of blank field b and max cannot handle max(blank,value,value), if so has this been documented somewhere?
Update: sorry that I did not clarify, I am using the fields as part of a formula in a workflow rule, so treating it a blank/ zero is not an option