3 Replies Latest reply: Feb 13, 2018 12:40 PM by Mark Bustin RSS

    Networkdays() Calculation Doesn't sort in table

    Mark Bustin

      Greetings,

       

      I use the following calculation to determine how many business days an action was in house before being closed - or currently in house if still open.

       

      if(Status='Closed',NetWorkDays(DateReceived,ClosedDate,$(vHolidays)) ,NetWorkDays(DateReceived,today(),$(vHolidays)))

       

      This function is supposed to return an integer, but sorting does not work on this column in a table.  I set the sort order to be numerical ascending, but no settings appear to make a difference.

       

      Does anybody know why the table behaves this way?

       

      Thanks,

      Mark