get multiple selected values for SET ANALYSIS

[#1]

Hi,

Does anyone know how to include multiple selected values for set analysis?

i came up with the following set analysis formula, but only allowed to select one value at a time.

when i select 1 product, amount is correct, it shows 0 when i selected multiple.

= ( Sum ( {$<Product={'$(= Product)'}>} (AMOUNT)) )

[#2]

Hi! Nicksatch

Try using this expresssion

= Sum ( {$<Product=>} AMOUNT)

[#3 · Accepted solution]

Nick,

another approach is:

Sum( {<SalespersonName={"$(=concat(distinct SalespersonName,'","'))"}>} LineSalesAmount)

Good luck!

Rainer

[#4]

Rahul, that formula actually returns all the values in product for you. it doesn't correspond to any selection user make.

Rainer's approach is what i used.

I'm still very amazed at how SET analysis works. I thought i'd need to include all the selection fields into the set formula, in fact, i just need to pick one, n QV will do the rest for me. I find it very strange, but, i guess it will take a while for me to accept this fact. 🙂