Gives me a total of 2.
Thus resulting in it reading the comma as a decimal place or seperator.
My question is, is there any way to force it to ignore the comma?
I have tried in the Parser, using:
So you DO want to use Substitute to remove the commas, but then you have to use the "string value" of the measure(s) so that you get the substituted string to use in the Calc measure.
A string like "1,234" is NOT a "number" in any programming sense. It can't be used in a Calc measure, or it will just return "1", since it will ignore anything after the comma. So we use the "string value" of the WebParser child measures, by using the [SectionVariable] form and DynamicVariables=1. That will get the substituted string value from the child, and then a Calc measure will happily turn "1234" into the real number 1234.
So you DO want to use Substitute to remove the commas, but then you have to use the "string value" of the measure(s) so that you get the substituted string to use in the Calc measure.
A string like "1,234" is NOT a "number" in any programming sense. It can't be used in a Calc measure, or it will just return "1", since it will ignore anything after the comma. So we use the "string value" of the WebParser child measures, by using the [SectionVariable] form and DynamicVariables=1. That will get the substituted string value from the child, and then a Calc measure will happily turn "1234" into the real number 1234.