If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Numeric to Text

Started by Meowzer, 18 Aug 2008 08:08:21 AM

Previous topic - Next topic

Meowzer

I want to create a column that gives a Yes/No answer if another field (numeric) is not null.  For example, if a sales count returned 515, I’d want a “Yes” to indicate that there were sales, else a “No” to indicate no sales.
.
I have tried IF (
.[COUNT] is not null) then (‘Yes’) ELSE (‘No’), but I get an error when I run the report.