Using SIN function with Expressions

Anonymous — Wed, 30 Sep 2015 14:59:52 GMT

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(2PI()/5)/2)/(1SIN(2PI()/5)/2))/5'
Timeliness	1	6	3	5	3	0	-49	51%		=((Timeliness Category Score * Completeness Category Score SIN(2PI()/5)/2)/(1SIN(2PI()/5)/2))/5'
Completeness	1	0	1	6	1	0	-13	87%		=((Completeness Category Score * Accuracy Category Score SIN(2PI()/5)/2)/(1SIN(2PI()/5)/2))/5'
Accuracy	0	0	3	1	2	0	-9	91%		=((Accuracy Category Score * Functinoality Category Score SIN(2PI()/5)/2)/(1SIN(2PI()/5)/2))/5/
Functionality	1	1	1	3	2	0	-18	82%		=((Functionality Category Score * Availability Category Score SIN(2PI()/5)/2)/(1SIN(2PI()/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

Anonymous — Wed, 30 Sep 2015 15:33:51 GMT

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

Anonymous — Wed, 30 Sep 2015 15:35:38 GMT

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

Wed, 30 Sep 2015 15:58:07 GMT

Try Above function...