I have a report that displays the amount of daily sales on an account but I woud like to dispaly the information in a cumaltive line graph rather than the daily total graph that I am currently getting.

 

The data axis I am curently using are:

 

on change of: invoice date show value of: sum of @outsatnding value

 

the outstanding value formula is:

 

({Command.goods_cash_ster}+{Command.vat_disc_ster})-{Command.cash_paid_ster}

 

The problem with the current daily sale graph is that when a payment/credit is applied the graph displays negative figures even when there is oustanding amount on the account.

 

Any suggestions are welcome.

 

Cheers

 

P