Jump to content

how to convert from field to full text format?


Recommended Posts


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:

image.png.b9db8d4c2dd62278fdaa0eb5402caa1f.png

 

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

image.png.131b225db3f97d59b8d6317bfa114717.png

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

Capturedcran2023-01-26152125.png.5c0d03e7e97dd59984607cde75db0550.pngimage.jpeg.9369644348d814efe88a830e327b48e9.jpeg

image.png

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

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

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...