Catherine Meyrat

How To Convert 0 Quantity To 1

As we already added a condition that if Quantity is not presetn in invoice line item then we use 1 as quantity in Quote Line Item.

But in some cases user put 0 in Invoice Line Item in QB, so how can we check quantity is 0 and if its 0 then convert it to 1.

See attached screen shot formula that we are using for quantity.

Best Answer

A

Adam Goh
said
over 3 years ago

Hi Catherine,

Yes that will be possible. What you'll be looking for is to have indented condition On the first true statement (after ?) You can have the second condition. The second condition you may use [Quantity] == '0' ? [Quantity] : 1It should look similar to this screenshot

This can be read as: "If JobID is present, check if JobID is equals to 4748. If yes, use 'statement is true', or 'statement is false1' if otherwise. If the jobID is not present use 'statement is false2'.

Cheers,

Adam Goh

Customer Success Team

Email : success@workato.com

Phone : +1 844 469 6752

Answer

Adam Goh

said
over 3 years ago

Hi Catherine,

Yes that will be possible. What you'll be looking for is to have indented condition On the first true statement (after ?) You can have the second condition. The second condition you may use [Quantity] == '0' ? [Quantity] : 1It should look similar to this screenshot

This can be read as: "If JobID is present, check if JobID is equals to 4748. If yes, use 'statement is true', or 'statement is false1' if otherwise. If the jobID is not present use 'statement is false2'.