Im transferring order invoices from Shopify directly into Xero, it works perfectly except one thing.
If there is a discount value on the order the spreadsheet style formula works great to turn the discount £ value into a % value.. perfect
But
If there is no discount on the order then when it hits the spreadsheet formula step the zap stops because there is no line items discount value.
My question is how do i create a step to check if there is no line items discount value then skip the spreadsheet formula step and move to step 3 and just create the invoice?
