If(
If(GetSelectedCount(Week_no)>0, sum({<Kpi_key={12}>}Successes)/sum({<Kpi_key={12}>}Total_files),
sum({<Kpi_key={12}, Week_no={$(vMaxWeekKPI12)}>}Successes)/sum({<Kpi_key={12}, Week_no={$(vMaxWeekKPI12)}>}Total_files))<0.8,$(vRedColorSummary),
If(
If(GetSelectedCount(Week_no)>0, sum({<Kpi_key={12}>}Successes)/sum({<Kpi_key={12}>}Total_files),
sum({<Kpi_key={12}, Week_no={$(vMaxWeekKPI12)}>}Successes)/sum({<Kpi_key={12}, Week_no={$(vMaxWeekKPI12)}>}Total_files))>=0.8 and
If(GetSelectedCount(Week_no)>0, sum({<Kpi_key={12}>}Successes)/sum({<Kpi_key={12}>}Total_files),
sum({<Kpi_key={12}, Week_no={$(vMaxWeekKPI12)}>}Successes)/sum({<Kpi_key={12}, Week_no={$(vMaxWeekKPI12)}>}Total_files)) <0.9,$(vAmberColorSummary),
If(
If(GetSelectedCount(Week_no)>0, sum({<Kpi_key={12}>}Successes)/sum({<Kpi_key={12}>}Total_files),
sum({<Kpi_key={12}, Week_no={$(vMaxWeekKPI12)}>}Successes)/sum({<Kpi_key={12}, Week_no={$(vMaxWeekKPI12)}>}Total_files))>=0.9, $(vGreenColorSummary)
)
)
)