jose_valooran
New member
- Joined
- May 23, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Dear friend,
I am tracking my delivery out figures. Now I want to track 1 year, 6 month, 1 month- monthly average whose results I want in a comparative line graph which gives result against today.(something similar to Moving avg. graph used by share traders for technical analysis..)
I have another problem in this. Some of my items is not in existence for 1 year. For such items formula should be( (total delivery/No of days from 1st delivery to today)*30 ).. similarly for all avg calculations......
Please find ATTACHED sample data
Thanks in Advance..
Kind Regards
Jose
I am tracking my delivery out figures. Now I want to track 1 year, 6 month, 1 month- monthly average whose results I want in a comparative line graph which gives result against today.(something similar to Moving avg. graph used by share traders for technical analysis..)
I have another problem in this. Some of my items is not in existence for 1 year. For such items formula should be( (total delivery/No of days from 1st delivery to today)*30 ).. similarly for all avg calculations......
Please find ATTACHED sample data
Thanks in Advance..
Kind Regards
Jose