3 Replies Latest reply on Oct 2, 2018 9:16 AM by Mavis Liu

    Auto calculated values based on date

    rao marapatla

      Hi All,

       

      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

      v10.5

       

      thanks in adavance