how to create running total with positive and negative numbers

[Snakedog12]

Hello,

I am trying to create a report that shows the totals of all checks sent to a supplier. Some of the checks have credits which show up as negative. But, the running total adds these amounts instead of subtracting. How do you get the running total to subtract the credit amount instead of adding it?

Thanks!

 

[MCuthill]

SnakeDog,

I am not sure how you are currently calculating your Running Total. I would try adding a catch such as:

[blue]Shared NumberVar[/blue] RunningTotal;
[blue]IF[/blue] {Table.CheqAmount} >= 0 [blue]THEN[/blue]
     RunningTotal:=RunningTotal + {Table.CheqAmount};
[blue]ELSE[/blue]
     RunningTotal:=RunningTotal - {Table.CheqAmount};

Not sure if this will help, if not please post information such as your report schematic, formulae used, Crystal & Database versions, etc.

Thanks,


Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[Snakedog12]

i got it! I just did

if {inv type}="dm" then {inv amt}*-1 else {inv amt}

Thanks for the help though!