Page 1 of 1

Difference in euro - Negative value but appgini marks 0

Posted: 2017-09-23 15:03
by facos79
Hi, in a table with 2 values A and B (prices) in euro currency I need to calculate the difference between C = A - B.
If C is a negative price, Appgini shows me 0 (Zero). How do I show the correct value?
Es.
A = 10.00 euros
B = 12.00 euros

A - B = -2.00 Euro but appgini displays A - B = 0


The field is DECIMAL 10.2

How can I fix the problem ?

Thank you.
Greetings

Re: Difference in euro - Negative value but appgini marks 0

Posted: 2017-09-23 17:55
by AhmedBR
Check UNSIGNED, if specified, disallows negative values.

Re: Difference in euro - Negative value but appgini marks 0

Posted: 2017-09-23 22:27
by facos79
Grazie.
Era proprio quello il problema.
Risolto. :)