how to use "OR" or "AND" functions in calculated fields of jasper domain designer?

[raja.shekar]

I need to create a calculated field that checks the two condition in "IF" statement of domain designer.

Example: field1='RAJ'

         field2='RAM'

         

so i need to create a calculated field f3 that should check field1 and field2 .

that is           if(field1=='RAJ' or field2='RAM',field1,'')

when i tried to use above statement i am getting the following error "An erorr occured while performing the previous request"

Please help me on this.

 

[ernestoo]

This worked fine for me with the following formula:

 

IF(("Subcategory" == 'Aspirin') or ("Product Name" == 'Plato Grape Jam'), 'Painkiller', '')

 

It seems in your case you are not "quoting" fields correctly and you are missing the "FalseCalc" part of the formula (ie after the last comma you have)

 

if("field1"=='RAJ' or "field2"='RAM',"field1",'something')