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
