i am trying to sum all values showing up under line items output but it's not coming up as a single value output
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Help us have more info by posting screenshots with how your Zap steps are outlined and configured in EDIT mode so we can see the field mappings.
- Beginner
I have attached the requested screenshots. In the Output (screenshot 5), I'm trying to have it be the sum of all the values appearing there instead of it showing as the individual line items with commas.
thanks in advance
+14- Zapier Orchestrator & Solution Partner
Try this Zap action: Formatter > Numbers > Perform Math Operation (Add)
- Beginner
so I added a step to remove the comma's from the line items output, then to add the numbers but i'm still getting an Invalid Syntax error, Only numeric values are allowed. Im thinking it's gettting the "-”(negative sign) as a non-numerical value. Any other work-around you can think of?
+14- Zapier Orchestrator & Solution Partner
- Answer
Looks like Formatter does not like an array of numbers.
So you will have to flatten the array.
Zap action: Formatter > Utilities > Line Items to Text
Set them to be comma separated.
⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
+6- Zapier Staff
That’s amazing
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.