Using Set Analysis

[eduardo_dimperio]

Hi everybody

I've some names to filter, like CAS-SUM and CAS-SUM NG

Already exist a code to get CONSUMO_MENSAL if name= CAS-SUM, but now i need to get CAS-SUM and CAS-SUM NG

How can i do this?

Sum({<NAME={"CAS-SUM"}, CORTADO={"Cortado"}>} CONSUMO_MENSAL)

I thought to do this Sum({<NAME={"CAS-SUM*"}, CORTADO={"Cortado"}>} CONSUMO_MENSAL), is this right or exist a better way to?

[ahaahaaha]

At first sight everything right and should work. Really Work? What's the question?

[marcus_sommer · Accepted solution]

You could use a value-listing like:

Sum({<NAME={'CAS-SUM', 'CAS-SUM NG'}, CORTADO={'Cortado'}>} CONSUMO_MENSAL)

and also a wildcard should work:

Sum({<NAME={'CAS-SUM*'}, CORTADO={'Cortado'}>} CONSUMO_MENSAL)

by using single-quotes to wrap the string-values.

- Marcus

[eduardo_dimperio]

The question is about the best way to do, if way that i did is more efficient.

[eduardo_dimperio]

Thank You Marcus !