Formatter Math Operations Error: “Invalid Syntax: Only numeric values are allowed”

Hi @Mariko 

Good question.

The reason for the Formatter error is because of the currency symbol.

Try using a Formatter > Text > Replace step to remove that symbol and return a number only to use.

Hi Troy,  Thank you for your reply.  I appreciate your help

I tried with no symbol

However, it turned out to be an error.

It seems there are another issue on this.. 

@Mariko 

The error indicates it expects a number w/o commas, otherwise it’s splitting the number at the comma delimiter.

Is there any way to turn a number into no commas?  The data comes in as it is from another app.

@Mariko 

Try using a Formatter > Text > Replace step to remove that commas and return a number only to use.

 Am I doing wrong?  not working as i expect..

@Mariko 

Try just a ,

@Mariko where you able to get the commas removed from your number by typing a “,” into the “Find” field instead of “[:comma:]? It looks like you’re so close to getting the result you’re after with your number formatting! Let us know!