7 Replies Latest reply on May 12, 2016 1:44 PM by Matthew Hefferon

    Working Day Calculation

    Matthew Hefferon

      Hello all,

       

      One of our database guys added a field called 'HQ Working Days' to our db. It's basically a flag that marks '1' for working days and '0' for non-working days.

       

      When I took a look at the number of working days for April and May I was expecting to see the associated working days but see values of 21,207 and 7,068. When I looked at the underlying data we use invoice date and there can be multiple invoices per day so instead of getting a '1' for each working day we are getting a '1' for each invoice date record.

       

      I attached a sample workbook but was wondering if there was a calculation or LOD expression to get the number of working instead of the many records a single day might have?

       

      Thanks