

Re: How to calculate a Expression based on a value of another expression which matches a selected value
Nitya Reddy Apr 24, 2017 7:40 PM (in response to Antonio Mancini)I laid out the data in this way so it is easy to understand but all my Expressions have calculations. In the example Average is straight feild but in my data it is a calculated expression. So in the data set where you have Average, It is a calculated expression with the formula Average: Sum ({1}RAW_COUNT)/Sum ({1}MBR_CNT). Now for the Selected Average when I try Only({1}TOTAL Average). It is not working.
Is it because my Average is not a field but a calculated expression? How can I use the same with calculated expression?

Re: How to calculate a Expression based on a value of another expression which matches a selected value
Staffan Johansson Apr 25, 2017 4:55 AM (in response to Nitya Reddy)If you want to use a already calculated Expression, use column(n) or the name of the Expression ex [Averages].
n in column(n) is the Expression number, ex for Averages use column(3)

Re: How to calculate a Expression based on a value of another expression which matches a selected value
Staffan Johansson Apr 25, 2017 5:05 AM (in response to Nitya Reddy)Or you can use set analysis like this: column(1)*Sum(total{1< State={'NY'}>} Averages)

Re: How to calculate a Expression based on a value of another expression which matches a selected value
Manideep Hv Apr 25, 2017 5:48 AM (in response to Nitya Reddy)Hi Nitya,
Please find the attached application to solve your problem.
Hope this helps!
Manideep

QV6.qvw 160.0 K


