The case of the disappearing Rounded Total

B

Beetlejuice

I've got a report set up as an invoice that sub-totals three fixed numbers
plus a rounded number (my tax calculation) and then gives me a total - No
problem - but when I try to add three of the sub-totals, it doesn't show up
on my report - Why is it hiding?
 
B

Bob Howard

maybe a bit obvious, but....

have you checked the Visible property on that control???
 
B

Beetlejuice

Yes - smarty pants - I did and it is marked as "visible" and I even double
checked to make sure my font colour was black!!! I can't figure this one
out. If I take out the ROUND commands along the way, it all comes back (but
then my figures get screwed up because of the tax calculation).
 
B

Bob Howard

Are any of these calculations being performed in VBA code, and if so, do you
have an error handler active that issues a message? It's possible that an
error causes termination before the total is computed.
 
B

Beetlejuice

Nope - that's not it either. It's a pretty simple set of calculations:

=Sum([Term1])
=Round([Sum Of Term1]*[GSTRate],2)
=Sum([CostumeTerm1])
=-[NumberofClasses]*10+10
=[Sum Of Term1]+[GSTTerm1]+[CostumeTotal]+[MultiDiscount]

There are three sets of these calculations (three terms) and these totals
all appear on the report but when I add them together:
=[TotalTerm1]+[TotalTerm2]+[TotalTerm3]+[Sum Of CostumeBal]
That Total does not appear on the invoice.

Then, I have a sub-form that shows the payments and when I try to give a
balance:
=[Grand Total]+Payment.Report!TotalPayments
That balance doesn't show up either.
 
Top