This content has been marked as final. Show 3 replies
hope you all doing good.
I have a requirement which I need to calculate values based on date example I have a sprint start date is 10/01/2018 starting of the sprint I allocate 80 hrs as default value ,when calender date changes this allocated value has to change with -8 which means on 10/02/2018 allocated value should show 72 ... on the end date which is 10/12/2018 allocated values should be 8.
when ever I open the report(current & future date only I don't want see old dates which means if I open report today 10/2/2018 I wil not look for 10/1/2018 data) based on the date this values has to display .
attached workbook ,please provide your inputs
thanks in adavance