Help on IF v. Set Analysis

[bazzaonline]

Hello,  I have the below expression which works fine at an overall level,

([NPSP])/sum(NPSS)-sum([NPSD])/sum(NPSS))*100

However I need to be able to add a criteria so it only works on a sub set of data.  In this case when the Dimension 'Flow' equals 'Rapid'.

How do I do this?  I tried

if(Flow='Rapid',sum([NPSP])/sum(NPSS)-sum([NPSD])/sum(NPSS))*100

but no joy.

Any ideas?

[simospa]

Hi Paul,

not sure I undesrstood what do you want...

Try to see  the attachment.

Let me know.

S.

[maxgro]

maybe

sum({$ <Flow={Rapid}>} NPSP) / ......

[Anonymous]

try.

sum({<Flow={'Rapid'}>}NPSP)/sum({<Flow={'Rapid'}>}NPSS)-sum({<Flow={'Rapid'}>NPSD}/sum({<Flow={'Rapid'}>NPSS}*100