Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

networkdays forward and backwards

BosKev
8 - Asteroid

Hello,

 

is there a way to build a process to account for not just start date, end date being sequential but able to tell number of days backwards as well?

 

I'm using the Networkdays process in the attachment. but I have some days that are backwards meaning start date is later than the end date but I still want to be able to determine # of days. Is there a way?

 

Thanks

BosKev

2 REPLIES 2
danilang
19 - Altair
19 - Altair

Hi @BosKev 

 

Before your Generate rows tool, add a formula tool that calculates CorrectedStart and CorrectedEnd and use these in your process

 

formula.png

 

Dan

BosKev
8 - Asteroid

Thank you! that works :)

Labels