check 3 _Greg.pbix (241.1 KB)
This is an example proposed by Greg Deckler, but we need to modify it to suit our requirement ,its not complete,
He said creating new columns for every month , to hold the updated cumulative balance is the only way to solve it.
Can you tell me more what the main idea behind that approach.
The updated closing balance with funding should be available for the next month’s funding determination.
So creating new tables to store that updated closing balance every month.
Thats what I understood!
check 3 _Greg_1_10.pbix (191.1 KB)
This is working, but the performance is really bad, when implemented in real scenario. Please let know if there is a better way out for this.
Thanks to the contributors to this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post and more visibility please start a new topic within the forum. You may check this how-to guide for reference - How To Use The Enterprise DNA Support Forum https://forum.enterprisedna.co/t/how-to-use-the-enterprise-dna-support-forum/3951