AGGR Fuction with SUM Set Analysis

Fri, 23 May 2014 08:25:07 GMT

Good Morning,

first of all many thanks for your attentions.

I semplify the question:

I have a Table with ACTIVITY,DOCUMENT,MILESTONE,ACTUAL_DATE and PROGRESS

i should calulated in DIMENSION sum of the documents PROGRESS group by ACTIVITY.

the value shouldn't take the filter on job document so i Worte a calculated dimension:

=AGGR(

sum({1}

if(ACTUAL_DATE <=TODAY(),PROGRESS)

)

,ACTIVITY)

and works OK.infact if i select one document the dimension value is 1100 beacuse sum all progress document of the activity

but this is not ok for me because,for the other reasons, i should aggregate also for DOCUMENT and so i wrote:

=AGGR(

sum({1}

aggr(

if(ACTUAL_DATE<=TODAY(),PROGRESS)

DOCUMENT,MILESTONE)

)

,ACTIVITY)

while, in this mode,
the value is 80...seems that if i aggregate for DOCUMENT the {1} not works ok.

Re: AGGR Fuction with SUM Set Analysis

Fri, 23 May 2014 08:29:28 GMT

Brian,

maybe this will be helpful:

Thu, 29 May 2014 07:17:54 GMT

many thanks!with only function seems works fine!!