average in set analysis

[Anonymous]

Hello Everyone

My instruction work correctly for each row but when you select some values in chart, it doesn't calculate correct avrage.

if(IsNull(RecieveMonth) ,Avg('42280'- SendMonth ), Avg(RecieveMonth-SendMonth))

i would much appreciate if any body here could helpme

[swuehl]

That's hard to answer without knowing any details. Could you post a small sample QVW?

You can also try to embed the if() into the aggregation function:

Avg(if(IsNull(RecieveMonth) ,42280, RecieveMonth)) - SendMonth )

[Anonymous]

Hi,

What does your 'SendMonth' and 'RecieveMonth' contains and which format?