Help with Set Analysis

[#1]

Hi Guys,

How do I make the following Set Analysis expression to work?

=Sum( {$< DB={'telcon'}, Part No= - {"ZI","ZP"}> } $(vOpOrdersAmountBalance)) / $(vSalesDivider1)

I need DB= 'telcon' and at the same time Part No <> from 'ZI', 'ZP'

Thanks in advance,

Aldo.

[separerl · Accepted solution]

Hi Aldo !

Try something like this:

=sum( {$<DB={'telcon'}, [Part No] -={'ZI','ZP'}>} $(vOpOrdersAmountBalance)) / $(vSalesDivider1)

Note the brackets around Part No and the placement of the minus-sign

/Pär

[mike_garcia]

Hi,

Does the variable $(vOpOrdersAmountBalance) return a Field Name?

Mike

[#4]

Yes, it returns a Field Name.

Aldo.

[#5]

It works,

Thanks,

Aldo.