calcul rate using the last day

[zied_ahmed1]

Hello,

I have to calcul rate and i use this in the script :

(sum(value)/ day((Date)) ) as Rate

Now i need to replace day(date) by the last day of the month

Thanks for help

Regards

[rahulpawarb · Accepted solution]

May be this:

Sum(value)/Day(MonthEnd(Date)) AS Rate

Regards!

Rahul