Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 |
May be like this:
Count({<EMPLOTEE_ID = {"=OverTime_HOURS/PLANNED_HOURS >= 0.101 and OverTime_HOURS/PLANNED_HOURS <= 0.15"}>} EMPLOTEE_ID)
May be like this:
Count({<EMPLOTEE_ID = {"=OverTime_HOURS/PLANNED_HOURS >= 0.101 and OverTime_HOURS/PLANNED_HOURS <= 0.15"}>} EMPLOTEE_ID)
Something like this
=Count({<%Overtime = {">=10.1 and <=15"}>} EMPLOYEE_ID)
Script:
hi das
{">=10.1 and <=15"}>}
do you think the 'and' is mandatory
{">=10.1<=15"}>}
Should do the trick