Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use the SIN function from Expressions that I am creating.
Dimension: SLA Category (values Availability-Timeliness-Completeness-Accuracy-Functionality)
Expressions: Critical: =count(DISTINCT {<[SLA Impact]={"Critical"}>}ID)
High: =count(DISTINCT {<[SLA Impact]={"High"}>}ID) Medium: =count(DISTINCT {<[SLA Impact]={"Medium"}>}ID)
Points Deducted: =(Critical *(-10)) + (High *(-5)) + (Medium *(-3)) Category Score: =Num((1) + ([Points Deducted]/(100)),'#,##0.%')
High
OOTC
Score Calculation
I have tried this express, but am getting an error -Error in set modifier element function name:
=((Sum({<Category Score={"Availability"}*Sum({<Category Score={"Timeliness"}>}*Sin(2*PI()/5)/2)/(1*Sin(2*PI()/5)/2))/5
Any help is greatly appreciated!
Dan