Revenue chart

[themr]

Hi,

I'm trying to make a financial tracking form for my company. It works well, except for one feature that I would want. That I fail to figure out how to make.

I want a chart that shows where the revenue will come (when invoices fall due). For example, If I have a project where I have sent four invoices as shown below:

Invoice no. 1 due 2011-12-09, invoice amount $ 100.
Invoice No. 2 due 2011-12-11, invoice amount $ 200.
Invoice No. 3 due 2011-12-11, invoice amount $ 150.
Invoice nr. 4 due 2011-12-14, invoice amount $ 300.

As you can see invoice no. 2 & 3 are due to be paid on the same day. So I want to find a way where I can get the following chart:

Revenue:
2011-12-09: $ 100
2011-12-10: $ 0
2011-12-11: $ 350
2011-12-12: $ 0
2011-12-13: $ 0
2011-12-14: $ 300
And so on…

Do you have any tips?

Thanks in advance!

(Please excuse my bad english)

/ / Kristian

[themr]

Hi again.

I've got the answer from another forum. Thanks anyway!

//Kristian