Difference in euro - Negative value but appgini marks 0

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
facos79
Veteran Member
Posts: 115
Joined: 2014-10-29 12:31

Difference in euro - Negative value but appgini marks 0

Post by facos79 » 2017-09-23 15:03

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

AhmedBR
AppGini Super Hero
AppGini Super Hero
Posts: 327
Joined: 2013-09-19 10:23

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

Post by AhmedBR » 2017-09-23 17:55

Check UNSIGNED, if specified, disallows negative values.
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper

facos79
Veteran Member
Posts: 115
Joined: 2014-10-29 12:31

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

Post by facos79 » 2017-09-23 22:27

Grazie.
Era proprio quello il problema.
Risolto. :)

Post Reply