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
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))
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))
thanks Braga Miguel
If my answer was the right one, please, mark it as the correct
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
can you upload the .qvw file sample plz