We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to use Network day formula in altreyx

MaheshR
7 - Meteor

Dear All,

 

Good day,

 

I want to use the network days formula to be used in altrexy. For your reference, I have attached my spreadsheet results.

 

Formula used as = Networkday(imported on - today)-1

 

Need your support.

 

Document Id     Imported On Today         Ageing     Slab

2471583706-11-2008-11-2000-1 Day
2471583806-11-2008-11-2000-1 Day
2470397105-11-2008-11-2010-1 Day
2470397205-11-2008-11-2010-1 Day
2470399105-11-2008-11-2010-1 Day
2469084904-11-2008-11-2022 Day
2469730904-11-2008-11-2022 Day
2469731904-11-2008-11-2022 Day
2469009103-11-2008-11-2033-5 Days
2469009203-11-2008-11-2033-5 Days
2469021903-11-2008-11-2033-5 Days
2469022003-11-2008-11-2033-5 Days
2469022103-11-2008-11-2033-5 Days
2469022203-11-2008-11-2033-5 Days
2469731001-11-2008-11-2043-5 Days

 

 

 

 

4 REPLIES 4
messi007
15 - Aurora
15 - Aurora

Dear @MaheshR,

 

There's actually a macro that was built to do this on the gallery: https://gallery.alteryx.com/#!app/Count-Weekdays/5862c055a18e9e0ff8d854cd.

 It also gives you the option to excluded some days like holidays.

 

Hope that helps 🙂

 

Regards,

Qiu
21 - Polaris
21 - Polaris

@MaheshR 

Macro from @messi007 is a good one. I give it a try and hope it helps.

1108-MaheshR.PNG

MaheshR
7 - Meteor

@tqu 

 

I am unable to download the file.  Can you please check and re-send it?

 

Regards,

Mahesh

Qiu
21 - Polaris
21 - Polaris

@MaheshR 
I unzip the package here. Hope it works for you.

 

Labels
Top Solution Authors