AVG DAYS

[Anonymous]

Hi all i am trying to derive Avg Days using following expressions it works exactly the way i want but as soon as i add dimension  PRODDATE , the dimension PRODDATE is not visble pls help

AVG(AGGR(COUNT({<PRODDATE= {">=$(vStartDate)<=$(vLastDate)"},EDITION_CAT={'M'},PUBLICATION_TYPE={'DS'},EDTION_TYPE={'Newspaper'}>}DISTINCT

(PRODDATE)),STATE_LINK,LINKCITY1,PUBLICATION_TYPE,CITYSAT,PRODUCT_CONTANT_CATEGORY))

Thanks In advance

Vinayagam

[swuehl]

Sorry, I don't fully understand.

the dimension PRODDATE is not visible ... Where it is not visible? In which context are you using this expression?

You might consider adding the set expression also to the outer aggregation (avg() function).

[Anonymous]

hi i am using this expression in Pivot table

[awhitfield]

Your expression is calculating over a date range, so how can there be a single PRODDATE?

Andy

[Anonymous]

agreed sir

But is any possible way of doing it as i want to show both days as well as AVG over period of time

Thanking You

Vinayagam