Expression error on using another Expression inside IF / AGGR Statement

[aurly123]

Hi,

I have the below expression (utilisation) evaluated under another expression having IF and AGGR statement on a PIVOT CHART. The expression for <50% is erroring out. What am i doing wrong, Any thoughts? Thanks!

Utilisation =Round(Max( {$<Date= {$(=Max(Date)'}>} {$<Metric = {"*off","*On"}>} [PEAK VALUE] /
Max({$<Date = {'$(=Max(Date))'}>} [CAPACITY])),.01)

Attached the <50% screenshot.

[Brett_Bleess]

Have a look at the following Design Blog post, believe that may help you figure things out, there are some related posts too, just FYI.

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett