I am writing a complex report using several VFP data tables. Within this report, I also use a few variables to calculate a total. This report has three different amount fields. The first one is a calculated total, the second is directly from a data table and the third is calculated difference from either the total amount or from the data table amount.

My first question is . . . Because I use several data tables; the calculated total amount shows several times. When this variable is repeated I need for the amount to be zero (other calculations are made from this amount). But I need to see all the other information from the other data tables. How can I zero this amount out?

Also within this same report, I need to have the calculated difference from either the total amount or from the data table (depending if the calculated total amount is not 0). How do I do this?