Please advise what I am doing wrong and how to correct this. Basically within a form I have a field that provides a calculation of current month vs previous months worth of business. The current month is a negative balance vs the previous month which is a positive balance. I pull the information from a 2 queries that establishes a sum total for the current months volume and another query that provides the volume sum total from the previous months. The totals are appearing on the form without issue. It is when I go to calculate the percentage between the two amounts that I am having the issue with.

Here is my formula:

=IIf(Nz([Text52])=0,0,NZ([GrossTotals]+[Text52])/[Text52])

Gross Total (current month) This is my negative amount
Text 52 (Previous month) This is my positive amount.

-3,404,663,743.66 (Current)
12,367,534,803.94 (Previous)
My percentage is not looking at the current as a negative number (I believe) =8962871060.28/12367534803.94=.72% It should actually be a -.72

Please advise how I get around this. I am truly baffled. I do not want to go and have to manually fix this every month. The database should do this automatically.
Thanks for your help.