Multiplying columns and static figures

Platform discussions
1

Hi All -
Looking to calculate the sum of 2 columns together and then multiply that sum by .09. In Excel, it would be
=sum({Rev}{GM%}).09
I can get the sum to work, but any time I add in the “*.09” it spits out an error.

Any suggestions? Thanks in advance!
AH

2

Hi Allison,

To multiply, use:

MULTIPLY({Number},0.09)

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.

3

Hi Giles -
I am trying to get a sum of two columns, and multiple that by .09. I have it set up as the below, should I modify?

MULTIPLY(SUM({Rev}{GM%})).09

Thanks!

4

Yes.

MULTIPLY(SUM({Rev},{GM%}),0.09)

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.

5

Got it - for some reason the formula column needed the “0.09” and not just the “.09” - strange.

Thanks for your help!