Custom query calculation

[dimoss]

Hi

I use the following as a custom query calculation in order to get the percentage.
(100 * SUM((%s))) / SUM(sinolo)

It works ok but I get 4 decimal digits (ex. 33,3333) and I would like to get only two decimal digits.
Any help?

Thanks.

 

[dimoss]

Friendly bump

 

[troester]

This is MySQL (not Fabrik).
Try ROUND((100 * SUM((%s))) / SUM(sinolo),2)

 

[dimoss]

Thanks Troester!
This did the trick...I need to read more SQL