Calculation Definiftion In Cognos Impromptu

[AndrewKent]

Hi there,

Can anyone tell me the syntax I need to use to achieve the following...

I wish to count all results in a data column that contain a certain text string (in my case it's the code "CTF" or "GLCP").

...can anyone help?

Andy

 

[drlex]

Andy
Use the TOTAL function (in Summaries) and associate it to the report.
Construct a data item like

total( if ( DATA_ITEM contains 'CTF' or DATA_ITEM contains 'GLCP' ) then ( 1 ) else ( 0 ) )

and make the association to the report (drop-down selection at the bottom of the 'Data Definition' window)

soi la, soi carré