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

[miguelbraga · Accepted solution]

You need to convert 42280 to month like this month('42280') and transform your function to this:

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

[Anonymous]

thanks Braga Miguel

[miguelbraga]

If my answer was the right one, please, mark it as the correct

[Anonymous]

oh dear yes you right but my "Sendmonth" is not a date format it's number like 42280 so in this case it doesn't need to convert

[ahmar811]

can you upload the .qvw file sample plz