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