how to convert from field to full text format?

[solene.masseron]

I have a table with a dormant stop field with yes/no values and I would like to count the yes value number and the no value number.  I have created a parameter as attached:

 

The problem is that I encounter this error message and I don’t know how to get around this problem

I tested these various formulas but I still encounter the same problem. help me.

[Thomas Tibcken]

Hi, 

please look at this topic that contains an simple example:

I tried this and it worked!

It also works with NOT

new Integer(!($F{STATUS}.equals("Completed")) ? 1 : 0)

 

How could it work if there is more than one condition.

($F{STATUS}.equals("Completed")

($F{STATUS}.equals("InProcess") ?

Hope that helps. 

Regards TT