Sum skript and then if colour

[kkarlste]

Hi

This is my skript and this not working. I don't understand what is wrong
Any help me

if(Sum({$<MonthKEY={"$(=Max(MonthKEY)-11)"}>}QC_EvaluationResult) QC_EvaluationResult> 0.8 and value < 1,2, green(), red())

[Abhishekb]

Hi  @kkarlste ,

Above you are using more than 2 parameters. Kindly correct it.

And 1 more issue is below you want to separate the condition by "AND" or "OR" operator.

[anat]

if(Sum({$<MonthKEY={"$(=Max(MonthKEY)-11)"}>}QC_EvaluationResult)> 0.8 and Sum({$<MonthKEY={"$(=Max(MonthKEY)-11)"}>}QC_EvaluationResult)<2, green(), red())