6 Replies Latest reply: Apr 2, 2017 10:07 PM by Erick Dameron RSS

    Sum by total number of work days

    Erick Dameron

      Hello everyone,

       

      I need to sum by the total number of workdays from beginning of data set to end.

      To do so I tried to use this formula but cannot nest the expression.

      I know that you can use AGGR to nest expressions but I have been unable to make it work.

       

      Any thoughts?

       

      1.)   SUM(DailyPT)*(MAX(NETWORKDAYS(MIN(visitdate),TODAY())-MIN(NETWORKDAYS(visitdate,TODAY()))))

      2.)   SUM(DailyPT)*(MAX(AGGR((NETWORKDAYS(MIN(visitdate),TODAY()))-MIN(AGGR(NETWORKDAYS(visitdate,TODAY())))))



      Update*

      Just realized that I cannot use NetworkDays because that function is counting the days, not finding.




      To summarize I need to sum by the number of work days inbetween the MIN(visitdate) and MAX(visitdate)