Skip to main content
Question

Formatter by Zapier error: The app returned invalid syntax; only number values are allowed.

  • Jan 9, 2024 7:20 PM UTC
  • 12 replies
  • 187 views

Good morning, I need some help, I have some prices obtained from the line items and these values ​​I have, I would need to divide them by 100. Can someone give me a hand? 

Thanks

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

12 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Jan 9, 2024 7:30 PM UTC

Hi @andy001 

To give us full context, please post detailed screenshots with how your Zap steps are outlined and configured.

You can try using a Formatter > Numbers step: https://zapier.com/apps/formatter/help


  • Author
  • New
  • Jan 9, 2024 7:37 PM UTC
i have this situation, 3 line items value, I need every single line item value must divide by 100

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Jan 9, 2024 7:42 PM UTC

@andy001 

You would need to try adding a value to divide by in the bottom input field.

 


  • Author
  • New
  • Jan 9, 2024 7:44 PM UTC

this can help? I have number of items, prices of items, and I need have tax value for invoice software, value need to be divided by 100


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Jan 9, 2024 7:51 PM UTC

@andy001 

Have you tried adding a value of 100 to divide by in the bottom input field?

 


  • Author
  • New
  • Jan 9, 2024 7:52 PM UTC
I read that if I have line items I need to use Spreadsheet-style formula
 

 


  • Author
  • New
  • Jan 9, 2024 7:55 PM UTC

yes give me an error


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Jan 9, 2024 7:56 PM UTC

@andy001 

Did you try testing the step to see the results? (e.g. Does 660 becomes 6.60?)

 


  • Author
  • New
  • Jan 9, 2024 8:01 PM UTC

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Jan 9, 2024 8:01 PM UTC

@andy001 

Can you post a screenshot of the error?


  • Author
  • New
  • Jan 9, 2024 8:04 PM UTC

in the previous post there is the error..  only numeric values are allowed

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Jan 9, 2024 8:05 PM UTC

@andy001 

I was able to replicate the error with the Formatter step.

You’d have to use a custom Code step to perform the math operation (divide by 100) on an array of item values.

Zap Code step have an AI helper that you can try to use.