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
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 )
What does your 'SendMonth' and 'RecieveMonth' contains and which format?
Retrieving data ...