Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
Hi,
Try like this using Aggr() like below
Sum(Aggr(IF(CATEGORY='Assessment' OR CATEGORY='Payment',
SUM(SECONDARY_TIME)/COUNT(DISTINCT NUM_PROCEDURE), (1)
SUM({$<FLAG_PHASE={'1'}MAIN_TIME)/COUNT({$<FLAG_PHASE={'1'}DISTINCT NUM_PROCEDURE)), USER,CATEGORY,SUBCATEGORY))
May be try with Aggregation. Like
=IF(CATEGORY='Assessment' OR CATEGORY='Payment',
Aggr(SUM(SECONDARY_TIME)/COUNT(DISTINCT NUM_PROCEDURE),CATEGORY,SUBCATEGORY),
Aggr(SUM({$<FLAG_PHASE={'1'}MAIN_TIME)/COUNT({$<FLAG_PHASE={'1'}DISTINCT NUM_PROCEDURE),
CATEGORY,SUBCATEGORY) )
Uhm, I've tried that but I still get Null
Can you Post the Sample?
May be try this. sum before Aggr. Like
=IF(CATEGORY='Assessment' OR CATEGORY='Payment',
Sum(Aggr(SUM(SECONDARY_TIME)/COUNT(DISTINCT NUM_PROCEDURE),CATEGORY,SUBCATEGORY)),
Sum(Aggr(SUM({$<FLAG_PHASE={'1'}MAIN_TIME)/COUNT({$<FLAG_PHASE={'1'}DISTINCT NUM_PROCEDURE),
CATEGORY,SUBCATEGORY) ))
Hi,
Try like this using Aggr() like below
Sum(Aggr(IF(CATEGORY='Assessment' OR CATEGORY='Payment',
SUM(SECONDARY_TIME)/COUNT(DISTINCT NUM_PROCEDURE), (1)
SUM({$<FLAG_PHASE={'1'}MAIN_TIME)/COUNT({$<FLAG_PHASE={'1'}DISTINCT NUM_PROCEDURE)), USER,CATEGORY,SUBCATEGORY))
Thanks! I used it with AVG(AGGR()) on the outside and it worked!!!