How to calculate networkdays in Paxata? Also, why is networkdays not supported in my version?

[l2evenge]

I am trying to calculate the networkdays between two dates.  I recognize that according to the documentation NETWORKDAYS is a supported function, but for some reason it does not exist in the version we are running:

2018.2.6.1.2519

[Melanie]

Hi there, NETWORKDAYS is a new computed column function that has been added in our 2019 release. Please contact your Paxata system administrators to determine the anticipated upgrade date for your site, which will enable this new functionality for you. Hope this helps!

[l2evenge]

Does anyone know of a means of making the calculation in the meantime?

[juno · Accepted solution]

You can register the java * .jar file (like below function) to the Paxata Custom Clustering algorithm, and then call it through the Hashvalue function in the Paxata calculation column.

https://svn.apache.org/repos/asf/poi/trunk/src/java/org/apache/poi/ss/formula/atp/WorkdayCalculator....

[Melanie]

To make this calculation, you will need to compute it based on DATEDIFF and multiplying by number of hours in a day. Here are some details from the help documentation on the DATEDIFF function:

DATEDIFF

Calculates the days, weeks, months between two dates.

Syntax:

	DATEDIFF(DATETIME_1, DATETIME_2, INTERVAL) DATETIME_1 is the date you want to start with. DATETIME_2 is the date you want to end with. INTERVAL is the interval type (minutes, days, years, etc.) you want returned. The following is a list of the recognized values for the INTERVAL value: Years Months Weeks Days Hours Minutes Seconds Millis
	Example: DATEDIFF(@Date Received@, @Date Shipped@, “months”)

:

Notes on use: The DATETIME you provide must be a datetime object, a column that contains a datetime object, or a function that returns a datetime object. The INCREMENT provided must be an integer. Millis accepts a maximum of +/- 2147483647. It is recommended you use the latest datetime value for the DATETIME_2. If you enter the earliest date as the DATETIME_2 value, the DATEDIFF function will return a negative number. DATEDIFF always rounds the result down to the nearest whole number. For example, if the difference between two dates is 3 years and 11 months, the DATEDIFF function returns the difference as 3 years.