Local variables not summing up numerical values properly

[leslie888]

test_sumList.rp (84.2 KB)

Issue

• When entering numbers in the text fields (positive, neg, decimal), the total number doesn’t sum properly
• Sum seems to be adding in additional numbers
  Sample file of what am trying to accomplish uploaded for reference

Goal

• Enter values in the “Count” column
• Values should be numerical only, can be positive or negative and may include up to one decimal
• “0” in the Overall total count column should adjust as numbers are entered in any text field in the sum column
• At time of submit, final value in the overall sum column should then populate on the start page + sum page

[UXProtoTyper]

I’ve run into similar issues where the decimals get off for whatever reason. You can force the result down to 1 decimal (or any other number of decimals) using .toFixed by doing something like this:

[[(LVar1 + LVar2 + LVar3 + LVar4 + LVar5 + LVar6 + LVar7 + LVar8 + LVar9).toFixed(1)]]

[nkrisc]

This is a problem with JavaScript, not specifically Axure:

4.1 - 0.1 = 3.9999999999999996 (Apparently)

This is a floating point math issue and is a common issue in computing when using floating point representations of decimals and is not unique to Axure. float - What causes floating point rounding errors? - Programmers Stack Exchange For example, try typing 4.1 - 0.1 in the console in your browser, you'll see the same thing. Or try 0.1 * 0.2. Same problem. I'm not sure what solutions there are. In other types of programming, you would usually avoid or mitigate the issue by using different …

One way around this is to used toFixed() to truncate the value, or instead don’t use decimals at all, but store your values as integers and then convert them to decimals when you display them. For example, instead of storing a price in dollars as 1.41, store it in cents as 141 and then divide it by 100 when you want to display it.

[Anthony_Axure]