Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
[Label Name1] * ((Count(Measure2)/Sum(Measure3))/(Count(TOTAL Measure2)/Sum(TOTAL Measure3)))
Assuming you have this
1) Sum(Measure1) -> Label1
2) Sum(Measure2) -> Label2 -> Relative...
You can do this
3) Label1 * (Sum(Measure2)/Sum(TOTAL Measure2))
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?
Try this
[Label Name1] * ((Count(Measure2)/Sum(Measure3))/(Count(TOTAL Measure2)/Sum(TOTAL Measure3)))
Like the attached?
It should be possible of what you want to achieve..may be providing a sample app would be great.
that worked! thanks so much!