NaN value on multiplying two columns [message #1800275] |
Sun, 23 December 2018 03:36 |
Alok Ranjan Messages: 4 Registered: November 2018 |
Junior Member |
|
|
Hi,
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.
|
|
|
Powered by
FUDForum. Page generated in 0.02938 seconds