5 Replies Latest reply: Aug 22, 2017 1:31 PM by Channing Dionisopoulos

# Multiplying 2 Expressions

Hi all!

I have 2 calculated expressions.  One column is a simple sum of a dollar amount.  The other column is a percentage calculation, with the relative box checked to make the percentages relative to the whole.  I want to multiply these two columns together, but it will not work since one column is relative and the other is not.  Can I multiply 2 expressions using the 'Label' I created for each expression?  Is there a function I can use to make one part of the equation relative and the other not relative?

Does anyone have any idea how to fix this?

Thank you

• ###### Re: Multiplying 2 Expressions

Assuming you have this

1) Sum(Measure1) -> Label1

2) Sum(Measure2) -> Label2 -> Relative...

You can do this

3) Label1 * (Sum(Measure2)/Sum(TOTAL Measure2))

• ###### Re: Multiplying 2 Expressions

Thank you for your response.  1) is correct. but 2) isn't just a sum.  it is: count(Measure2)/Sum(Measure3).  Also, can Label1 have spaces in it?  Does that matter?

• ###### Re: Multiplying 2 Expressions

Try this

[Label Name1] * ((Count(Measure2)/Sum(Measure3))/(Count(TOTAL Measure2)/Sum(TOTAL Measure3)))

• ###### Re: Multiplying 2 Expressions

Like the attached?

It should be possible of what you want to achieve..may be providing a sample app would be great.

• ###### Re: Multiplying 2 Expressions

that worked! thanks so much!