Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have one year data(Fields are Date,Sales,Item,Branch)...i have to generate all dates between min(Date) and max(Date)..then i have to find cumulative sales for each Date(Order by Date)...
i Tried this.. but it took 2 hours to Generate cumulative for one month data...is there any Solution to reduce my loading time
EX:(Input)
Date Sales
1/1/2016 10
3/1/2016 40
4/1/2016 30
6/1/2016 10
Output should be like this
Date Sales
1/1/2016 10
2/1/2016 10
3/1/2016 50
4/1/2016 80
5/1/2016 80
6/1/2016 90
please find the attached.
comment the master calender field you don't want.
regards
Pradosh
Hi
Pleas see the attached app.
Regards
Pratyush
Hi ,
I dont know whether this code reduce the loading time... i will work on it
Hi Pratyush,
I am not getting the cumulative value while executing this code
If you want only date keep the date part only . you can delete the others .The code i have taken from Creating A Master Calendar Don't forget to do full accumulation in the expression tab. Which is the main reason behind the accumulation.
hi,
I need to do the accumulation in back end itself