Remaining Value of running total

[edavis248]

Hi all - From the below, I have a contract value that repeats for 1 contract which is its original vlaue. I want the "Column" to take the original Contract total minus the invoice amount to show as getting smaller and smaller after each invoice. 

So the first line in the  "column" column would be $142,576 minus the $2,084.85 giving me the $140,491.15. Then the next line would start with the $140,491.15 and subtract the next invoice $3,817.44. Currently, it is just taking the Original contract amount, "Contract Total" and subtracting every invoice but not as a running total. This seems alot more complicated than originally though due to the amount of posts on this. Appreciate any help ASAP. Thank you!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[edavis248]

https://drive.google.com/file/d/1HD-EKoByAP6y76SOOQ0591x5g0gRf9To/view?usp=drivesdk 

hi - I just had to make a simple version of my secure data. As mentioned. I just want a column that takes the original contract amount (which is static) minus each invoice. But I want the contract amount to get smaller as each invoice is paid. So my first line should be $150,000 minus invoice 1 for 100,000. Than the next line would start with $100,000 and so on.

[lbendlin]

access is denied - please check

[edavis248]

Hi Ibendlin- It looks like I cannot share because of the company protection on the file. The data I used is simple. The real source data is much more complex but the general gist is to have the contract amount decrease as invoice is paid in its own column. Thanks for trying.

[lbendlin]

You say you want the remaining invoice amount to decrease yet in your expected result it is increasing?

[edavis248]

I tried granting access another way.https://drive.google.com/file/d/1rZuznBfi4YxOekxLjkFCFTdCLBHzTBTs/view?usp=drivesdk 

[edavis248]

Hi - Yes sorry that was jsut for the example, So what I want it to do is have the invoice amount subtract from the contract amount. But I want the new value in the "amount remainging to start the next row. So create a running total only getting less in amount. 

So I would have $150,000 - 50,000 and then have the next line start as $100,000 instead of 150,000 again then subtract that from the next invoice -50,000 and so on until there is not amoutn to be invoiced left.S So I would have a decreasing new contract amount. 

Contract AMount	New Contract Amount	invoice amount	invoice amoutn remaining
150,000		50,000	100,000
	100,000	50,000	50,000
	50,000	50,000	0