I'm trying to write a row-level formula that sums up four different fields and I want to suppress any blank fields. My thought is that converting blanks to zeroes is probably the best course of action. However, when I try to write the code, I get various error messages. Line 1 of the formula is
Opportunity.Spring_Seats__c + Opportunity.Summer_Seats__c + Opportunity.Fall_Seats__c + Opportunity.Winter_Seats__c
I then move to line 2 and try to write
ISBLANK(Opportunity.Winter_Seats__c), "0"
and receive the error message "Error when encoding row-level formula: Syntax error. Extra ISBLANK"
(the fields in the report image here were renamed recently).
Thanks so much! I don't have admin privileges in my organization, so this is the route to go unfortunately. That solution definitely sounds easier.
