Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 )
Hi,
What does your 'SendMonth' and 'RecieveMonth' contains and which format?