Forum Discussion
By Period Expense Forecast vs. Total Invoices
Hello, This is my first time posting -- I apologize in advance for any incorrect protocol. The calculation I am trying to solve is to chip away at Total Invoices received for the year with ...
v-yuta-msft
Community Support
Community SupportAnonymous ,
Could you share some sample data and clarify more details about expected value?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for your reply. Please see the two attachments for sample data.
Please note that the columns highlighted in gray are samples of the actual data that I have. The columns highlighted in green are the calculated values that I'd like to be able to display in a visual. Please note that the second picture below is the same data as the first picture, however I have displayed the formulas that I am using to calculate the green-header columns.
Thanks again!