Set Analysis

[Anonymous]

Hello,

I have the data like this. Here I'm calculating the %Over time. = OverTime_Hrs/PlannedHrs

Now I'm trying to calculate the Number of staff who worked  in between >= 10.1 to <=15% in a text box. Please advise.

stalwar1

EMPLOYEE_ID	PLANNED_HOURS	ACTUAL_HOURS_DOC	OverTime_HOURS
62143	440	595	155
62238	440	588	148
62626	440	467	27
62735	440	547	107
62793	440	600.2	160.2
63465	440	499.5	59.5
63563	440	93	0
63898	440	447	7
4242	440	487.5	47.5
64366	440	442	2
64829	440	577	137
65120	440	517.5	77.5

[sunny_talwar · Accepted solution]

May be like this:

Count({<EMPLOTEE_ID = {"=OverTime_HOURS/PLANNED_HOURS >= 0.101 and OverTime_HOURS/PLANNED_HOURS <= 0.15"}>} EMPLOTEE_ID)

[rupamjyotidas]

Something like this

=Count({<%Overtime = {">=10.1 and <=15"}>} EMPLOYEE_ID)

Script:

[#4]

hi das

{">=10.1 and <=15"}>}

do you think the 'and' is mandatory

[rupamjyotidas]

{">=10.1<=15"}>}

Should do the trick