Forum Discussion
Help with virtual table/advanced summarize?
Hey team, I facing the following scenario. I have financial data of receipts and invoices for our customers and I need to figure out the amount of 'active debtors' at the end of each week. I am a...
4-3-3 , Make sure there is no join between week date and leave date/effective for this formula, or you have used crossfilter to remove that
Refer
I remember I downloaded, initial file. If you can give me sample output, I will try
Sorry, I responded to your first post first without reading this one. I have a join between the tables in the file that I just posted.
Although I just quickly removed the join and I am still not getting the correct amount. It is giving 810.15 now..