Adding more variables to set analysis

[#1]

Hi,

I have the below formula that says to include only sales with a value greater than 1 so to exclude any credits

sum({$<Sales>1>} Sales)

I want to know how to add more than one variable to the set analysis and include TL_Cust = 'M001' or TL_Cust = 'D001'.

e.g. I used to do:

sum(if(Sales >1 and TL_Cust = 'M001' or TLCust = 'D001',Sales))

How do I add this in set analysis

Thanks

Dave

[#2]

Do you get correct results using your set

<pre>sum({$<Sales>1>} Sales)

I think, it should be something like this

sum( {$<Sales={"=Sales>1"},TL_Cust ={ 'M001','D001'}>} Sales)

[#3]

Is it posible use greater in set analysis ?

I think use only equal ( = )

example)

=Sum ({$<Sales={1},TL_Cust={'M001','D001'}>} Sales)

[#4]

Richy wrote:Do you get correct results using your set

Yes this set does work great, no problems with the > sign so far

Richy wrote:sum( {tiny_mce_markerlt;Sales={"=Sales>1"},TL_Cust ={ 'M001','D001'}>} Sales)

This also worked perfectly, Thanks!

David