3 Replies Latest reply: Sep 30, 2015 11:33 AM by

# Using SIN function with Expressions

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.%')

Critical High   Medium Low None Repeats Points Deducted Category Score OOTC Score Calculation 1 SLA Categories 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 =((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

• ###### Re: Using SIN function with Expressions

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))

• ###### Re: Using SIN function with Expressions

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))

• ###### Re: Using SIN function with Expressions

Try Above function...