4 Replies Latest reply: Jun 16, 2016 12:42 AM by qvhelp please RSS

    Aging with only business days

    qvhelp please

      Hi all , i created below calculated dimension for aging   ,i do not want the weekends to get calculated in aging i want only the bushiness days to be calculated as aging .can anyone please help.

      =if(Interval(today() - CreatedDateText,'DD') >=0 and Interval(today() - CreatedDateText,'DD') <= 5, '1-5Days',

      if(Interval(today() - CreatedDateText,'DD') >=5 and Interval(today() - CreatedDateText,'DD') <=10, '5-10Days',

      if(Interval(today() - CreatedDateText,'DD') >=10 and Interval(today() - CreatedDateText,'DD') <= 15, '10-15Days',

      if(Interval(today() - CreatedDateText,'DD') >=15 and Interval(today() - CreatedDateText,'DD')<= 20,'15-20Days',

      if(Interval(today() - CreatedDateText,'DD') >=20 and Interval(today() - CreatedDateText,'DD')<= 25,'20-25Days',

      if(Interval(today() - CreatedDateText,'DD') >=25 and Interval(today() - CreatedDateText,'DD')<= 30,'25-30Days', 'Above 30 days'))))))

       

      gwassenaarswuehlmaxgrombaeyensmrkachhiaimpkush141087stalwar1sorrakis01

        • Re: Aging with only business days
          Sunny Talwar

          May be like this:

           

          =if(NetWorkDays(CreatedDateText, Today()) >=0 and NetWorkDays(CreatedDateText, Today()) <= 5, '1-5Days',

          if(NetWorkDays(CreatedDateText, Today()) >=5 and NetWorkDays(CreatedDateText, Today()) <=10, '5-10Days',

          if(NetWorkDays(CreatedDateText, Today()) >=10 and NetWorkDays(CreatedDateText, Today()) <= 15, '10-15Days',

          if(NetWorkDays(CreatedDateText, Today()) >=15 and NetWorkDays(CreatedDateText, Today()) <= 20,'15-20Days',

          if(NetWorkDays(CreatedDateText, Today()) >=20 and NetWorkDays(CreatedDateText, Today()) <= 25,'20-25Days',

          if(NetWorkDays(CreatedDateText, Today()) >=25 and NetWorkDays(CreatedDateText, Today()) <= 30,'25-30Days', 'Above 30 days'))))))

          • Re: Aging with only business days
            susant Kumar swain

            Add one more If condition at the top

             

            If ( match( weekday(CreatedDateText) ,'1','2','3','4','5' )   ,

             

            all your If condition )

             

            or you can filter out only Monday-Friday in the backend and use the same If condition

              • Re: Aging with only business days
                qvhelp please

                you mean like this ?

                 

                =If (match(weekday(CreatedDateText) ,'1','2','3','4','5')  ,if(NetWorkDays(CreatedDateText, Today()) >=0 and NetWorkDays(CreatedDateText, Today()) <= 5, '1-5Days',

                if(NetWorkDays(CreatedDateText, Today()) >=5 and NetWorkDays(CreatedDateText, Today()) <=10, '5-10Days',

                if(NetWorkDays(CreatedDateText, Today()) >=10 and NetWorkDays(CreatedDateText, Today()) <= 15, '10-15Days',

                if(NetWorkDays(CreatedDateText, Today()) >=15 and NetWorkDays(CreatedDateText, Today()) <= 20,'15-20Days',

                if(NetWorkDays(CreatedDateText, Today()) >=20 and NetWorkDays(CreatedDateText, Today()) <= 25,'20-25Days',

                if(NetWorkDays(CreatedDateText, Today()) >=25 and NetWorkDays(CreatedDateText, Today()) <= 30,'25-30Days', 'Above 30 days')))))))

                 

                this is not working