Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Formula to Calculate Expected Payment of Invoice

BrandonS4
8 - Asteroid

I have the below columns in an Excel document. I am curious what formula I can put in column E to calculate when payment will be expected based on average days to pay.  In this example, this customer pays 15 days late so I know payment is expected 05/15/20 but what formula will show me that?

 

BrandonS4_0-1587669812185.png

 

 

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

Hi @BrandonS4 I mocked up a workflow let me know what you think. It produces the date in alteryx format which is YYYY-MM-DD and also in your original format as well.

 

Dates_23042020.JPG

BrandonS4
8 - Asteroid

When I run those formulas, my values come back as null.

BrandonS4
8 - Asteroid

Actually, just my payment expected format is coming back with null.  It says the format is not a valid Date.

JosephSerpis
17 - Castor
17 - Castor

Hi @BrandonS4 can you provide an sample excel file with just that row of data.

BrandonS4
8 - Asteroid

I got it to work.  I just had to change the way the date was being formatted and now it is showing correct.  Thank you so much for your help and your quick reply!

Labels