I have a formula (percent) with maximum summary type in a saved search with the following formula below. It looks like the error is caused by “SUM part”. Is there a way to restructure this in a way that NS would accept? CASE WHEN {targetutilization} = 0.00 THEN 1.00 ELSE SUM({time.durationdecimal})/40 END

If you are using summarization functions within the formula you need to use summarization functions on all variable. Try CASE WHEN MAX({targetutilization}) = MAX(0.00) THEN MAX(1.00) ELSE SUM({time.durationdecimal})/MAX(40) END

Ohhh yeaah actually, I knew that but I didn't try it on 40. Thank you!