Avg Function produces wrong result.

[MuraliPrasath]

Hi All,

I'm using below script in bar chart as a reference line. 

I first get the interval of two dates ex:(End Date - Start Date)

then

if Start Date is greater than End Date then show as '0'.

then Aggr and Avg . 

=Avg(Aggr(if(
sum(12 * (Year([Valid Date]) - Year([Submission Date])) + Month([Valid Date]) - Month([Submission Date]))>0,
sum(12 * (Year([Valid Date]) - Year([Submission Date])) + Month([Valid Date]) - Month([Submission Date])),0)
,ProductName,Country))