How to use formulas in Orca Scan

Formulas make it easy to calculate total weights, item quantities versus total value, or cost and quantity.

How to Add a Formula Field

You can add a formula field using either the mobile and web application:

How to Add a Formula Field via the Web App

1. Right-click a column and select Add Column
2. Give your new column a name
3. Set the data type to Formula
4. Click Add to add the column

How to Add a Formula Field via the Mobile App

1. Scan a barcode or tap to edit an item in the list
2. Tap the cog next to any of the fields
3. Give your new field a name
4. Set the data type to Formula
5. Tap Save to add the field

How to create a Formula

From either mobile or web:

1. Edit or add your formula field
2. Select the first column for your calculation
3. Select a calculation method (divide, multiply, add and more)
4. Select another column to complete the calculation
5. Tap Save

Now, refresh the mobile app, scan a barcode, and see your formula in action 🚀

Powerful Formulas for Orca Scan

Formulas in Orca Scan can automate calculations, making your work faster and more accurate. Here’s how to set up and use some key formulas:

Total Stock Value

Calculate the total value of your stock by multiplying the quantity by the price:

1. Create a Quantity and Price column

• Add a new column Quantity, assign it a Data type of Number
• Add another column Price, assign it a Data type of Number
• Save your changes
• Enter the quantity and price for each item

1. Create a Total Stock Value column

• Add a new column Total Stock Value, assign it a Data type of Formula
• Set the formula: Quantity x Price
• Save to apply the formula

Total Weight

Determine the total weight by multiplying the weight of each item by its quantity:

1. Create a Weight & Quantity column

• Add a new column Weight, assign it a Data type of Number
• Add a new column Quantity, assign it a Data type of Number
• Save your changes
• Enter the weight and quantity for each item

1. Create a Total Weight column

• Add a new column Total Weight, assign it a Data type of Formula
• Set the formula: Quantity x Weight
• Save to apply the formula

Reorder Quantity

Know how many items to reorder by subtracting current stock from the reorder level:

1. Create a Reorder Level and Current Stock column

• Add a new column Reorder Level, assign it a Data type of Number
• Add a new column Current Stock, assign it a Data type of Number
• Save your changes
• Enter the quantities for each item

1. Create a Reorder Quantity column

• Add a column Reorder Quantity, assign it a Data type of Formula
• Set the formula: Reorder Level - Current Stock
• Save to apply the formula

Now, you’ll instantly see the quantity needed to reorder. This works seamlessly with the low stock notification trigger.

Calculate Discounted Price

Easily calculate the discounted price of an item by applying a percentage discount to the original price.

1. Create a Price column

• Add a new column Price, assign it a Data type of Number
• Save your changes

1. Create a Discounted Price column

• Add a column Discounted Price, assign it a Data type of Formula
• Set the relevant discount rate: Price x 0.8 (for a 20% discount)
• Save to apply

Profit Per Item

Find your profit by subtracting the cost from the sales price:

1. Create a Sales Price & Quantity column

• Add a new column Sales Price, assign it a Data type of Number
• Add a new column Quantity, assign it a Data type of Number
• Save your changes
• Enter the sales price and quantity for each item

1. Create a Profit column

• Add a new column Profit, assign it a Data type of Formula
• Set the formula: Quantity x Profit
• Save to apply the formula

If you want to take it a step further, you could can also calculate your cost field vs total price to discover true profit.

1. Add a new column for each element of costing a project, assign it a Data type of Number. For example: Parts, Labour and Packaging.
2. Add a new column Cost Field, assign it a Data type of Formula
   • Set the formula: Parts + Labour + Packaging
   • Save to apply the formula
3. Add a Total Profit column
   • Add a new column Total Profit, assign it a Data type of Formula
   • Set the formula: Sale price - Parts - Labour - Packaging
   • Save to apply the formula

You’ll now be able to see clearly within your sheet, how much each element of your product costs, the sales price and true profit - even as the cost of production changes.

Questions about Formulas?

We’re always happy to help, chat with us live or drop us an email.