Aggregate in textbox with conditions

[sifatnabil]

Hi,

I have a straight table chart with

Dimension: TradeID

Expressions:

1. Buyer - concat(Buyer,',')

2. Seller - concat(Seller,',')

3. Trade Type - if(wildmatch(concat(Bank,','),'*Bank X*'), 'VOICE','ELECTRONIC')

How can I express this in a textbox where I want to display the count of VOICE and ELECTRONIC trades?

Thanks for your help.

[JonnyPoole]

Try this in a list box.  I'm putting the 2nd count two lines below the first.

'# Voice Trades: ' &  count (  if( wildmatch( Bank, '*Bank X*') , Bank ) ) 

& chr(10) & chr(10) &

'# Electronic Trades: ' & count( if ( not wildmatch( Bank, '*Bank X*') , Bank) ) 

[rwunderlich]

='VOICE: ' & count({<Bank={'Bank X'}>}TradeID)

='ELECTRONIC: ' & count({<Bank=-{'Bank X'}>}TradeID)

-Rob

http://masterssummit.com

http://robwunderlich.com