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.%')
SLA Categories | Critical | High | Medium | Low | None | Repeats | Points Deducted | Category Score | OOTC Score Calculation | OOTC Score Calculation Formula |
---|---|---|---|---|---|---|---|---|---|---|
Availability | 2 | 2 | 0 | 2 | 3 | 0 | -30 | 70% | =((Availability Category Score * Timeliness Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5' | |
Timeliness | 1 | 6 | 3 | 5 | 3 | 0 | -49 | 51% | =((Timeliness Category Score * Completeness Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5' | |
Completeness | 1 | 0 | 1 | 6 | 1 | 0 | -13 | 87% | =((Completeness Category Score * Accuracy Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5' | |
Accuracy | 0 | 0 | 3 | 1 | 2 | 0 | -9 | 91% | =((Accuracy Category Score * Functinoality Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5/ | |
Functionality | 1 | 1 | 1 | 3 | 2 | 0 | -18 | 82% | =((Functionality Category Score * Availability Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5' |
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
I have also tried this expression and still am getting the "Error in Expression:"
=((Sum([Category Score]='Availability' *Sum([Category Score]='Timeliness' *sin(2*Pi()/5)/2)/(1*sin(2*Pi()/5)/2))/5))
I have also tried this Expression and still get the "Error in Expression"
=((Sum([Category Score]='Availability' *Sum([Category Score]='Timeliness' *sin(2*Pi()/5)/2)/(1*sin(2*Pi()/5)/2))/5))
Try Above function...