Issue with Average

[#1]

Hi All,

I had come up with a scenario, where I should calculate the number of days between two dates for a particular instance. Then after calculating the days between them, i need the avg of those days.

So, in the expression I gave avg(Days), when I cross check the data manually it is varying.

So should i write something else in the expression??

Kindly help me in this scenario.

Thanks,

Sindhu

[MK_QSL]

Number of Days between two Dates...

Interval(Date2-Date1,'dd')

But don't get the logic behind Avg of this !

[maxgro]

avg(Date2 - Date1)

[#4]

Hi,

I had calculated the number of days with networkdays formula, where i'm able to achieve the days.

But the issue with calculating the average of all those days.

Eg..

3

4

5

6

these are the days with respect to some instance, now the average of (3,4,5,6) i need, when i use avg(days) its giving wrong results.

Hope this gives an idea.

[MK_QSL]

You should use

Aggr(Avg(Days),YourDimension)

[#6]

I have tried, but it didn't work.

[MK_QSL]

Provide me some proper 10 lines sample data. Would like to help you on this matter...

[#8]

Hi Manish,

Thanks for your help.

I missed one logic in the script, now I have fixed and able to get the results.