custom function or expression

I have configured datasource as oracle DB in ireport and am doing a select on a table. Is it possible to create a custom function or expression while adding a variable in ireport?
Below are some of the things i am trying to do:

1) Need to calculate the total on a column. But the data from DB is in varchar (mixed with numbers, NA, etc...). So i have to check the data and if has number, i have to convert it to big decimal and calculate the total. I tried inbuilt total function but, since the data from DB is varchar it is not calculating the total.
2) Also i need to calulate the average, so i should consider only the numberic values for calculating the average. Plz help.

example data in DB: 1 5 10 NA 0
Expected Results:
Total = 1+5+10 = 16
Average=16/4 (4 coz NA should not be counted)= 4

Post edited by: mohanchandar, at: 2008/07/09 21:32
mohanchandar's picture
Joined: Jul 9 2008 - 5:53am
Last seen: 15 years 2 months ago

0 Answers:

No answers yet