Display decimal as a percentage

Need help Database
1

Hi all,

I have an invoice page where users can add an item, such as “sheet glass” with a price of, say £100.

The user can save a VAT amount they wish to add in their settings, which is stored as a decimal, so 0.25 would display as 25%.

When viewing an invoice, I need to show the item price, in this case £100 but times that with their VAT amount, so I would show £125.

But, if I show Item's price * User's VAT I get £25 (100x0.25).

I have tried several variations but am not getting it, wondered if someone has solved this?

2

You have to show like that

Item’s price + Item’s price * User’s VAT

1 Like
3

Thank you, that’s it!