1 Reply Latest reply on Apr 25, 2018 3:39 PM by Patrick Van Der Hyde

# Show cash flow depending on down payment date and credit date

Hi, I have some sales data extracted from BW.

There are customer id, document id, payment terms (like 0/100 - 100% credit, 20/80 - 20% down payment/80% credit and so on), down payment date, credit payment date, net value.

Basing on payment terms I could evaluate down payment and credit parts.

And now i want to show on timeline at what time money should be payed.

For example, sales data:

Customer
DocID
PaymentTermsDown payment date
Credit payment date
Net order Value
CustomerA100110/9030.12.201730.09.201810000\$
CustomerB10020/100null30.09.20184000\$
CustomerC1003100/015.01.2018null5000\$
CustomerD100450/5030.03.201830.09.20188000\$

So on chart for X axis i want to have timeline 2017-2018 and on Y Down payment value (by date), Credit payment value (by date), SumValue (by date).

As i previously mentioned I've calculdated Down payment as NetOrderValue * Payment terms %, for Customer B it would be 8000*50%=4000, and same for Credit payment value.

So i want to organize data looks like:

Calendar date (X)Down payment value (Y1)

Credit payment value (Y2)

30.12.201710000
15.01.201850000
30.03.201840000
30.09.2018017000 (9000 + 4000 + 0 + 4000)

Could someone help me to understand how to mix two date fields into one inside Tableau?

In power BI i could use external Calendar dimension for that. But here I couldn't find similar functionality.

• ###### 1. Re: Show cash flow depending on down payment date and credit date

Hello Evgeniy,

I am not completely following what you are doing here but typically when is see two dates like this, I find the data is not organized well to accomplish date differences.   Are the down payment and credit payment dates in different data sources or on different rows of the same data source or is this one row of data?

One great resource you may want to look at is here: Current vs Previous Period to Date Comparison   There are several other date examples in the Workbook & Calculation Library.

Patrick