cancel
Showing results for 
Search instead for 
Did you mean: 

Print Category code if =

Former Member
0 Kudos

Hi,

I have a report with a category field that is a string value. The string values are from '0' to '999'

I want only to print if the value of the string is between 0 and 190.

I would like to know how to show the value if CATEGORY = 0 or CATEGORY = 1 or CATEGORY = 2 then show value, I can do it if I enter 190 lines LOL, but there must be a way to do a formula between 0 and 190.

Any ideas ?

Thanks,

Debbie

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Debbie,

Try:

If Tonumber({Category}) IN [0 TO 190] then

...

-Abhilash

Former Member
0 Kudos

Thanks for the quick response....that worked

Answers (0)