Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » NaN value on multiplying two columns(NaN value on multiplying two columns)
NaN value on multiplying two columns [message #1800275] Sun, 23 December 2018 03:36
Alok Ranjan is currently offline Alok RanjanFriend
Messages: 4
Registered: November 2018
Junior Member

I am struggling to fix one issue but could not find the solution anywhere.

There is one column name called Local Currency with string datatype.
In the mapping list, we have 90 list of numeric codes like AED to 0.2722644 so that we can convert another column called Amount to Amount in USD by multiplying Amount* conversion value.
So I created a new columN called Conversion value and mapped all 90 codes in the map tab of BIRT.The datatype was string.
Now since we cannot convert string column to float, I created another column called Local Conversion Value In Float with float datatype.
In expressio, I used parseFloat() to convert into float. The value is displayed as float.
But when I now mutiply the Amount with Local Conversion Value In Float, it gives NaN value.
I am sure Local Conversion Value In Float is still treated as string.
Does Float*Float give Float or not?
Please help.
Previous Topic:BIRT bar chart y-axis labels overlapping the bar
Next Topic:Filter in BIRT layout
Goto Forum:

Current Time: Tue Nov 12 19:19:45 GMT 2019

Powered by FUDForum. Page generated in 0.01477 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top