Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Try this:
Sum({<MASTERHIS_PRD_CD = {'AB*', 'CD*'}>} TRFIN_QTY)