Identify multiple values in data

system · October 19, 2009, 2:49pm

Hi,

I am trying to identify multiple values as shown in the following example:

SALESORDERNUMBER CUSTOMERNAME
============== =============

111 A1 ICE CREAM
111 A1 PIZZA
112 ITALIAN RESTAURANT
113 CHINESE RESTAURANT
114 THAI RESTAURANT
114 GREEN COOK HOUSE

From the above data set

Salesordernumbers 111 and 114 more than one customername assigned.
How do I identify salesordernumbers 111 and 114 from the above dataset in Deski.

Thank you

Venki

kgav1 (BOB member since 2009-10-19)

system · October 20, 2009, 7:45am

Try:

Count(<CUSTOMERNAME >) In (<SALESORDERNUMBER >)

[Moderator Edit: Added code formatting - Jansi]

pablolee (BOB member since 2008-07-29)

system · October 20, 2009, 1:52pm

Thank you.

It worked.

Venki

kgav1 (BOB member since 2009-10-19)