negative calculations

[sjhf]

Not sure if this is within CF or MySQL, but I have a item with I want to
multiply quantity by a negative dollar value. The number and amount are both
prepopulated from a MySQL database. It seems to not calculate the negative
number and resets it to 0 on the display page after the calculation is done.
The database save the quantity as a negative ok, but not the dollar value.

Any advice?

[sjhf]

Not sure if this is within CF or MySQL, but I have a item with I want to
multiply quantity by a negative dollar value. The number and amount are both
prepopulated from a MySQL database. It seems to not calculate the negative
number and resets it to 0 on the display page after the calculation is done.
The database save the quantity as a negative ok, but not the dollar value.

Any advice?

[SafariTECH]

a negative should be possible if a negative is actually coming from the DB data

try outputting the initial data to see what it shows, or even look in the data
tables themseleves to see if the field is allowing negative values.

are you sure the output isn't just showing up as ($23.99) - brackets do
indicate negative values.

[sjhf]

Yep. I checked the database and it was. I was wondering if there was anything
special to do with DollarFormat. It's at the point it tries to calculate that
it calculates at 0. All positive number calculations are fine.

[SafariTECH]

What do you see if you simply use #ExtraTotal# instead of DollarFormatting it?
does it show a negative decimal number?

If you use #DollarFormat("-23.99")# you should get (23.99) which is negative.
Therefore outputing the variable in dollarformat should do the same.