Set analysis + sum qty with type start with 'AB' and 'CD'

[jim_chan]

Hi guys,

a simple one i guess.

I want to create a set analysis - sum of qty but only type of  start with AB and CD. In my data now, i have these data 'AB_qwwertwr' and 'CD_zxbcmsjkf'.

Can this work???

sum(if(left(<MASTERHIS_PRD_CD,2)='AB' or left(MASTERHIS_PRD_CD,2)='',TRFIN_QTY))

[sunny_talwar]

Try this:

Sum({<MASTERHIS_PRD_CD = {'AB*', 'CD*'}>} TRFIN_QTY)