topic Re: Networkdays() Calculation Doesn't sort in table in App Development

Networkdays() Calculation Doesn't sort in table

mrbustin — Thu, 08 Feb 2018 14:28:29 GMT

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

Re: Networkdays() Calculation Doesn't sort in table

sunny_talwar — Thu, 08 Feb 2018 17:12:47 GMT

I don't think it should behave like this, would you be able to share a sample?

Re: Networkdays() Calculation Doesn't sort in table

Digvijay_Singh — Thu, 08 Feb 2018 18:53:59 GMT

What happens if you click on the column heading? Looks like order is load order, you should be able to change order from sorting options in properties.

Re: Networkdays() Calculation Doesn't sort in table

mrbustin — Tue, 13 Feb 2018 17:40:27 GMT

I tried modifying the sort options - doesn't work. Below are 2 screenshots where I tried changing the sort order by clicking on the column heading note the arrow ... -Mark