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
Adding multiple formulas in one field
This topic has been closed for replies.
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.
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
Also, you does not need the parentheses because of the operation order (multiplications goes before sums).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.