Solved

[microwin88x]

Solved

[settu_periasamy]

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) )

[microwin88x]

Uhm, I've tried that but I still get Null

[settu_periasamy]

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) ))

[jagan · Accepted solution]

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))

[microwin88x]

Thanks! I used it with AVG(AGGR()) on the outside and it worked!!!