add set analysis

[fdelacal]

i don´t know where i put the set analysis.

num((sum({$<STAFFID= {"*"}-{"0000*"}>}if(STATUSBOOK<5,GSP_BOOKING.SESSIONDURATION_XOR))*24)

/

(sum(aggr(if ( not isnull((GSP_STAFFTIME.ETIME -GSP_STAFFTIME.STIME)),sum(GSP_STAFFTIME.ETIME -GSP_STAFFTIME.STIME),0),STAFFID,STARTDATE))*24),FormatoNumPorcen)

I NEED PUT THIS.

FECHA = {"$(='>='&WeekStart('$(vFechaWeeklyReport)'-7)&'<='&WeekEnd('$(vFechaWeeklyReport)'-7))"}

REGARDS

[Gysbert_Wassenaar]

There are three sum functions in that expression. That gives you eight possible combinations. Try them all and see which one gives the correct result.