This is a cash flow indicator at a future date. In a full company database, it takes the cash account in the GL, accounts payable table, accounts receivable table, customer orders and purchase orders. For AP and AR, we use the amount outstanding at a certain due date. For CO and PO, it is the amount due at due date + 30 days. The formula is TotalCash = Cash + AR + CO – AP – PO. Furthermore, since these tables list transactions by transactions, there is a column that is a running total. This is for each day.
On the board, there is a slicer where the start date is today and the user can specify whatever future date he wants. The slicer is configured ‘after’. I have a card showing him what the total cash will be on that day. Now the user wants to do ‘what if ‘ scenarios. What if my customers (AR) pay me late by 30 days, how will that affect my cash flow? What is I pay my suppliers late by 15 days, how will that affect my cash flow? So for AR & AP, I need to change the due days for the AR transaction’s due date + what ever number the user selects.
I have tried using a what if parameter for AR and one for AP. On the board, when I show the measure, it shows the selected value. Let’s say 10. But in the table, if I try to add it to my column formula, it always shows 0. I tried to add a measure. However, the measure either shows 0, or I need to aggregate, and I do not want a sum or average. I’ve noticed that what it does is not pass the value but the 1 to 30 table (number of days in the parameter). So the sum is always 365 and the average is 15, no matter what the user selects as a value. Even when using the value measure.
Maybe the what if parameter is not the way to go. I need suggestions.
Thank you.
