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

    Networkdays() Calculation Doesn't sort in table

    Mark Bustin



      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?