Multiplying 2 Expressions

[#1]

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

[sunny_talwar]

Assuming you have this

1) Sum(Measure1) -> Label1

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

You can do this

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

[#3]

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?

[sunny_talwar · Accepted solution]

Try this

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

[sasiparupudi1]

Like the attached?

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

[#6]

that worked! thanks so much!