How to multiply a value with a number

Questions › How to multiply a value with a number

Thomas asked 2 years ago

Hello,

a value is stored in database without VAT. In grid this value should be displayed incl. VAT, for example +19% (*1.19)

How can I do this?

Thank you

1 Answers

Abu Ghufran Staff answered 2 years ago

Hello,

You can either do this calculation and formatting in sql query: e.g.

select vat+vat*0.19 as vat, field2, field3 from table.

Another way it to use on_data_display event and do it in php. e.g.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework

Your Answer