[Case Statement in Jaspersoft Domain Calculated field?]

Hi Hishamkmr,

i have copy paste the same code and i have changed the column names and i have tried the error occurs and i have cleared the blank spaces and tried but the same result...

 

Any other views...

[Case Statement in Jaspersoft Domain Calculated field?]

Hi Hishamkmr,

 

I have tried with the above answer but i have encountered the following error "Found '&&' after end of expression"

 

Any other Suggestions...

 

Thanks in Advance,

 

Robert J

[Case Statement in Jaspersoft Domain Calculated field?]

Dear All,

I am trying to create a domain calculated field that has case statement, i am trying the below statement for the calculated field

case
when column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) between 0 and 0.35 then '0.25 Ton'
when column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) between 0.351 and 0.85 then '0.5 Ton'
when column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) between  between 0.851 and 1.35 then '1 Ton'
when column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) between  between 1.351 and 2.25 then '2.0 Tons'
when column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) between  > 2.25 then '2.5 Tons'
end

this query is working fine in oracle, but when i use this statement in calculated field it was showing as "Cannot evaluate expression"

Where i am making the mistake or how to make this above statement possible in Jaspersoft?

Kindly guide me...

Thanks in Advance,

Robert J