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
24715837 | 06-11-20 | 08-11-20 | 0 | 0-1 Day |
24715838 | 06-11-20 | 08-11-20 | 0 | 0-1 Day |
24703971 | 05-11-20 | 08-11-20 | 1 | 0-1 Day |
24703972 | 05-11-20 | 08-11-20 | 1 | 0-1 Day |
24703991 | 05-11-20 | 08-11-20 | 1 | 0-1 Day |
24690849 | 04-11-20 | 08-11-20 | 2 | 2 Day |
24697309 | 04-11-20 | 08-11-20 | 2 | 2 Day |
24697319 | 04-11-20 | 08-11-20 | 2 | 2 Day |
24690091 | 03-11-20 | 08-11-20 | 3 | 3-5 Days |
24690092 | 03-11-20 | 08-11-20 | 3 | 3-5 Days |
24690219 | 03-11-20 | 08-11-20 | 3 | 3-5 Days |
24690220 | 03-11-20 | 08-11-20 | 3 | 3-5 Days |
24690221 | 03-11-20 | 08-11-20 | 3 | 3-5 Days |
24690222 | 03-11-20 | 08-11-20 | 3 | 3-5 Days |
24697310 | 01-11-20 | 08-11-20 | 4 | 3-5 Days |
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,
@MaheshR
I unzip the package here. Hope it works for you.
User | Count |
---|---|
56 | |
27 | |
25 | |
23 | |
21 |