Skip to main content
Question

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

  • January 9, 2024
  • 12 replies
  • 90 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
  • 34020 replies
  • January 9, 2024

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
  • 6 replies
  • January 9, 2024
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
  • 34020 replies
  • January 9, 2024

@andy001 

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

 


  • Author
  • New
  • 6 replies
  • January 9, 2024

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
  • 34020 replies
  • January 9, 2024

@andy001 

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

 


  • Author
  • New
  • 6 replies
  • January 9, 2024
I read that if I have line items I need to use Spreadsheet-style formula
 

 


  • Author
  • New
  • 6 replies
  • January 9, 2024

yes give me an error


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34020 replies
  • January 9, 2024

@andy001 

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

 


  • Author
  • New
  • 6 replies
  • January 9, 2024

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34020 replies
  • January 9, 2024

@andy001 

Can you post a screenshot of the error?


  • Author
  • New
  • 6 replies
  • January 9, 2024

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
  • 34020 replies
  • January 9, 2024

@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.