Summing Values

[AshleyDaniel]

Hi everyone, 

I am trying to sum my values by issuers so I converted the value's data type to Int16. However, when I do that the numbers change and I am unsure why. Am I using the wrong data type? 

Thanks for the help!

 --> 

[Qiu · Accepted solution]

@AshleyDaniel 
you data has thousand comma (,), need to remove that first.

[MarqueeCrew]

I'm looking at this on my phone. It looks like there are commas in your numbers.  That means that these are strings.  

use a multi-field formula where you can convert them to numbers as:

tonumber(replacechar([_current field_],",",''))

 please excuse any syntax issues with my iPhone expression. 

cheers,

 mark

[Qiu]

@AshleyDaniel 

Here is the sample flow.

[AshleyDaniel]

Yes this was the issue. Thank you all for the help! (:

[Qiu]

@AshleyDaniel 
thank you for the accept mark also.