Is Negative numbers possible while calculating multiple select values

  • engagewisdom
    Asked on April 6, 2020 at 2:37 AM

    For a Select Multiple form entry, with calculation values assigned to each option, It appears that the calculation value is always the sum of the items selected. Is that the only option? Are other functions available, like the product of the selected values?

    And although I've added some negative numbers as values, it appears to sum the absolute value of the selected items. Is there any way to include negative values and get the true sum?

  • metin
    Replied on April 6, 2020 at 9:34 AM

    Hello Charlie,

    You right, when you use multiple selection in a calculation form it will sum all selected values. But you can give negative numbers to calculation values. Here i created an example and i used negative value for second option. You can see in screenshots it works.

    Is Negative numbers possible while calculating multiple select values Image 1 Screenshot 90

    Is Negative numbers possible while calculating multiple select values Image 2 Screenshot 101

    Is Negative numbers possible while calculating multiple select values Image 3 Screenshot 112


    Is Negative numbers possible while calculating multiple select values Image 4 Screenshot 123

    And for your other question, if you want to apply other type calculations, my advice is to use input table. On calculation widget you can use every each row/column value. Here some screenshots for example :

    Is Negative numbers possible while calculating multiple select values Image 5 Screenshot 134

    Is Negative numbers possible while calculating multiple select values Image 6 Screenshot 145

    Is Negative numbers possible while calculating multiple select values Image 7 Screenshot 156

    Is Negative numbers possible while calculating multiple select values Image 8 Screenshot 167

    If you have got any questions, don't hesitate to ask.