3 Replies Latest reply: Aug 9, 2012 7:34 AM by Luca Jonathan Panetta RSS

    how to exclude saturday and sunday from 0-30 days bucket

    ajeet tomer

      Hello, all dear community members. Please solve my issue..

       

      i have a bucket as below, i want to exclude all saturday and sunday if i make selection of days upto 7 days stock, upto 15 days stock, upto 30 days stock. suppose i select 0-30 days so here 21 of days stock i need to calculate.

       

      i have bucket like this:

       

      if([Submission Days from Invoice]>=0 and [Submission Days from Invoice]<=7,'0-7',

                             

                             

         if([Submission Days from Invoice]>=8 and [Submission Days from Invoice]<=15,'8-15',

              if([Submission Days from Invoice]>=16 and [Submission Days from Invoice]<=30,'16-30',

                   if([Submission Days from Invoice]>30,'>30 Days')))) as [Doc Submission Bucket from Invoice],

       

       

      thanks

      ajeet singh