Skip to main content

hi there,

 

I am trying to create an invoice with different vat rates and the data is coming from stripe as follow fro the 3 items invoiced

tax_rates:(,20,10)

so the first Item as NO vat, the second one has 10% rate and the last one is 20%)

the outcome from zap for each item is as follow

  • Item1:””
  • item2:”20,10”
  • item3:”20,10”

how can I get from tax_rates:(,10,20) this 

  • Item1:”0”
  • item2:”20”
  • item3:”10”

Thank you for your help

Hi there @cwr,

Welcome to the Community! 🎉

You can probably use the Formatter (Numbers > Spreadsheet-Style Formula) action to convert the null (empty) line item to "0".

The following post that shows an example of how this works:

Hopefully, this helps!