Hi Dear Friends;
I need help by creating expression formula to calculate monthly based.
I want to calculate sales quantity. But I also want to calculate especially in a such way ;
When I select a date from calendar I want to see total calculate for "monthstart - selected date" period.
Forexample ; Today : 15.11.2011. So daily I want to show in the table "Monthly Sale" for fifteen days.Because in the november we left fifteen days.
An this will be for the sixteen days and go on.
And Please Assume that I choose a date from calendar. That is 05/03/2010. I should see sale amount for only three days. after one day this should be only for four day.
I can make this for 2011 but my formula fails for the previous years. You can see my formula in the attached file.
I am looking forward to seeing your support please.
Thanks in advance
