Adding multiple formulas in one field


#1

I’m trying to create a formula to add up two sums. i.e.

(ProductA* Sales) + (ProductB * Sales)

Is it possible to do, and how can it be done if so?

Thanks


#2

It can be done, and pretty much exactly as you have it there!

When you first start making formulas, use the picker that shows up at the bottom to fill in your field names so that you can get a feel for how they are formatted. Other than that, you can use math operators as you’d expect to, with respect to order of operations.


#3

Ah it wasn’t working at first, then I checked and one of the columns I was trying to add wasn’t set as a number! Thanks


#4

Also, you does not need the parentheses because of the operation order (multiplications goes before sums).