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
May be this:
Sum(value)/Day(MonthEnd(Date)) AS Rate
Retrieving data ...