Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I have been looking around for an answer to solve this and tried everything I can come up with, but I am still stuck here..

 

What I want to do is simple; divide a variable by two.

putting input field 1. a variable set by previous step,  2. 2

 

This turns out 

The app returned "Invalid Syntax: Only numeric values are allowed".

 

 

I also tried Spread-sheet style formula as   4.output: 5,000,000/2 and (4.output: 5,000,000)/2, as well as 

Quotient(4.output: 5,000,000,2)

 

any other ideas implement divide by 2??

please help me out...

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 “t:comma:]? It looks like you’re so close to getting the result you’re after with your number formatting! Let us know!

Hi friends! 👋🏽 I wanted to summarize a few of the points here into one answer. 

 

As Troy mention it looks like the error is occurring due to the currency symbol. He also recommended using a Formatter > Text > Replace step to remove the commas and return only a number.

In the find field searching for “ ,  “ may be useful in lieu of “comma” may help.

 

Terms & Conditions