Error adding two values from a list help me


the right answer would be
552+210=762
it’s not adding up, just joining
552210

Hi, make sure that your values are numbers and not texts, using NUMBER(var1) + NUMBER(var2) will also help!

1 Like


It worked

and the division by the number 60 did not work

Hi, that’s because 1+1/2 = 1+0.5 = 1.5 and (1+1)/2 = 2/2 = 1 Put parentheses around the addition to divide the whole sum

1 Like



it worked, thank you very much

is there a way to limit the number of places after the comma?

Check out this formula function: FORMAT_LOCALIZED_DECIMAL - Composer


the list values ​​are out of order
I don’t understand why

Hi, the formatting turns it into a text so you cannot divide it anymore. If you want to keep it as a number, FLOOR() rounds it to the nearest integer :slight_smile: