Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
IF (((Sum ({<ActivityType={'FSRV'} >} _Hours_worked)+Sum ({<ActivityType= {'INEN'}>} _Hours_worked)+Sum ({<ActivityType= {'ISSS'}>} _Hours_worked)+Sum ({<ActivityType= {'IDOA'}>} _Hours_worked))/[Target Inst Hours])
<0.3,1,0))
>0.1,1,0)))
Hope somebody can provide some guidance.
Many thanks in advance.
Kind regards;
Kristel
num#
(
If(
sum(
If(ActivityType='INEN'OR ActivityType='ISSS'OR ActivityType='IDOA',1,0)
+
IF(
(
(
Sum ({<ActivityType={'FSRV'} >} _Hours_worked) +
Sum ({<ActivityType= {'INEN'}>} _Hours_worked) +
Sum ({<ActivityType= {'ISSS'}>} _Hours_worked) +
Sum ({<ActivityType= {'IDOA'}>} _Hours_worked)
)
/[Target Inst Hours]
)
>1.5,1,
IF (
(
(
Sum ({<ActivityType={'FSRV'} >} _Hours_worked)+
Sum ({<ActivityType= {'INEN'}>} _Hours_worked)+
Sum ({<ActivityType= {'ISSS'}>} _Hours_worked)+
Sum ({<ActivityType= {'IDOA'}>} _Hours_worked)
)
/[Target Inst Hours]
)
<0.3,1,0
)
)
>0.1,1,0
)
)
)
You can further make it more readable by replacing this:
Sum ({<ActivityType={'FSRV'} >} _Hours_worked)+
Sum ({<ActivityType= {'INEN'}>} _Hours_worked)+
Sum ({<ActivityType= {'ISSS'}>} _Hours_worked)+
Sum ({<ActivityType= {'IDOA'}>} _Hours_worked)
with this:
Sum ({<ActivityType={'FSRV','INEN','ISSS','IDOA'} >} _Hours_worked)