robert.j
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by robert.j
-
-
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
-
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'
endthis 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
Case Statement in Jaspersoft Domain Calculated field?
in Products
Posted
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...