Forum Discussion
Visualizing historical balance
I am building visuals for providing a view of invoice balances based on a date selection. Based on selected date, the view will show the invoices and the amount owed by customer and a chart with...
Hi Anonymous ,
Did my formula work for you? Let me know if i miss something.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Ashish_Mathur
Sorry for the delay in my reply.
The ask is to show the Due amount details based on a date .
From the above data, if the date selected is 11/20/2017, only the first transacation should be displayed as the $1600 is due as of 11/20/2017 and the rest of the orders belongs to 2019 or they are all greater than 11/202/2017
Hi,
Has your question been answered?