Jobber error: Invalid Syntax: Only numeric values are allowed

Hi @WorkflowMagic 

The data is formatted as line items, so follow the guidance of the tip.

@Troy Tessalone thanks for the reply.. so when using that I get an error.. Do I need to separate the line items? 

@WorkflowMagic 

Try this formula:

SUM([VARIABLE],0)

@Troy Tessalone I did not get an error with that formula but the outcome is not correct.. The deal amount should sum to $350. Am I missing a step?

 

@WorkflowMagic 

Try to first convert the line items to text with this action: Formatter > Utilities > Line Items to Text

@Troy Tessalone now I get the original issue The app returned "Invalid Syntax: Only numeric values are allowed".

 

@WorkflowMagic 

You should map the 1 variable that has all the concatenated text values.

Can you post screenshots with how your Formatter > Utilities > Line Items to Text

@Troy Tessalone yes, I shared it in the second photo but resharing 

@WorkflowMagic 

Can you show the OUTPUT from that Formatter step?

@Troy Tessalone 

@WorkflowMagic 

Try mapping this variable.

@WorkflowMagic

If that doesn’t work, then a Code step can be used to loop the values and SUM.

https://zapier.com/apps/code/help

@Troy Tessalone I believe the output text worked, thank you very much!!

That’s awesome @WorkflowMagic! Big thanks to Troy for lending a hand here.

Happy Zapping! ⚡️