Hello there. I have a set of purchase orders with a payment term. I have only one record for each PO in the database, with the date being the supposed billing date which is my starting date where i add days for the payment.
What i'd like to accomplish in Tableu is to evenly split the amount of money to be paid in each period. But again, i have only one record with one date in the DB.
I calculated the amount of each installment and though about creating calculated fields for each payment date but i'm having a hard time to put them in the correct period, because, as stated before, in the database I only have one record but need to display 2,3 or more records (depending on the qty of installments)
This is what i'd like to accomplish:
PO | PAYMENT TERM | MONTH | |||||||
AMOUNT | 0 (current month) | 1 | 2 | 3 | 4 | 5 | 6 | ||
1 | 60/90 days | 100 | 50 | 50 | |||||
2 | 60/90/120 days | 300 | 100 | 100 | 100 |
The dataset is something like:
PO | TERM | AMOUNT | REQUIRED_DATE |
1 | 60/90 | 100 | SOME DATE |
2 | 60/90/120 | 300 | SOME DATE |
I'm trying hard not to generate new records in the DB table.
*Honk the Community horn*
I have this thread opened since yesterday and I don't seem to understand this one.
Calling for our brightest community members! Would you be able to save Gabriel A. Zorrilla?
Become a Viz Whiz on the Forums! Support the Community and master Tableau.