I am trying to calculate if a support case breached the SLA time. However, I don't want to calculate the breach time if there is a null value in one of the fields. I have tried the below but get an error.
IF(NOT(ISNULL(Flexible_SLA_Time__c >
CASE(b1_case_severity__c,
"1 - Critical", 9.5,
"2 - High", 9.5,
"3 - Medium", 19,
"4 - Low", 28.5, 0),
1,
0
))))
Error when encoding row-level formula: Incorrect number of parameters for function 'IF()'. Expected 3, received 1