Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following table
Budget:
load * inline
[
Plant,Month ,Value,Year
P1,Jan,100,2016
P1,Feb,100,2016
P1,Mar,100,2016
P1,Apr,100,2016
P1,May,100,2016
P1,Jun,100,2016
P1,Jul,100,2016
P1,Aug,100,2016
P1,Sep,100,2016
P1,Oct,100,2016
P1,Nov,100,2016
P1,Dec,100,2016
];
the above budget table by month
I want to make it day wise data i.e i have sum up the Value and divide by 365 (sum(Value)/365) and group by Plant
LOAD Plant,
Year
Sum(Value)/365 as DailyAverage
From XXXx
Group by Plant,Year;