Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i have a scenario that i have fields called STARTDATE and ENDDATE, i need to calculate only CurrentWeek, Nextweek and Next following Week (eg: current week 37, need to show data only for 37,38,39) excluding Weekends
For example:
I have a data for
startdate,enddate, value
13/09/2017,26/09/2017,7
06/09/2017,27/09/2017,5
WEEK is filter:
my calculation should be
Current week= in this week remaining days(3)= 7*3= 21 and 5 *5= 25 total =21+25=46
Nextweek= in this week remaining days(5)= 7*5= 35 and 5 *5=25 Total=35+25 = 60
Nextweek= in this week remaining days(2)= 7*2= 14 and 5 *3=15 Total = 14+15= 29
like this
Thanks
Kk
Hello Kiran,
Please can you drop a sample QVW file so we can see what's you want to achieve?
Regards
Hi Akpofure,
please find the attached excel for your reference
StartDate | EndDate | value | Current week | next week | next folowing week |
6-Sep | 27-Sep | 2 | 10 | 10 | 6 |
9-Sep | 12-Sep | 2 | 4 | 0 | 0 |