Cognos Impromptu 7.4 --> if gender is "M" then "0"

[JanHumanitas]

Hello,

Simple question:
I want to define a filterdefinition inside a report that covers the statement in the subject area:
I want to add a "0" instead of "M" in my report. (there a 2 variables in de database "M" and "V", male, female)

Hope you could help me out.

Jan

 

[UcfMike]

I maybe misunderstanding you, but it sounds like using a conditional format could do what you want.

 

[CognosProfessional]

sounds like a data definition of if then else.

IF (X = 'M') then ('O')
else
IF (X = 'V') then (X)

CP