Decimal and calculation

Hello,

I would like to do an automatic calculation with decimals:
Example:
Cb_number1 + cb_number2 = cb_number3
0.001 + 0.002 = 0.003
I do not know if this is the right method, I have the addon Query field
I wrote: SELECT (`cb_number` +` cb_number2`) FROM `#__ comprofiler` WHERE` id` = '[cb_number3]' in the section "CB QUERY Fied"
It does not work
Thank you for your help
Jérôme

Doesn't work because id is the user_id of the user in _comprofiler. You need to check `id` = '[user_id]' and in your select add number 1 and 2 together. Example as follows.


cb_number 3 would just be your query field.

Merci ça fonctionne !

Et pour utiliser les décimales ? y-a-t'il une solution ?
Merci
Jérôme

It should use decimals assuming your values are stored with decimals as it's just adding the 2 values together. If you're using an integer field you can't have decimals. It needs to be a text or float field and since we've no float field types you'll need to use a text field.