Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Number of Days between two Dates...
Interval(Date2-Date1,'dd')
But don't get the logic behind Avg of this !
avg(Date2 - Date1)
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.
You should use
Aggr(Avg(Days),YourDimension)
I have tried, but it didn't work.
Provide me some proper 10 lines sample data. Would like to help you on this matter...
Hi Manish,
Thanks for your help.
I missed one logic in the script, now I have fixed and able to get the results.