Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2013-06-06 07:31 AM

how to do math operation with BigDecimal datatype

Hi,
I just wonder, how do i wants to do mathematics operation (add, subtract, multiply, divide etc) with data type bigdecimal. It such a problem when using float or double since the value will be rounded and makes my calculation inaccurate. My source currently having long decimal places almost 20 decimal point.
Plz help me 0683p000009MPcz.png

Regards,
Kal
Labels (2)
Labels
521 Views
0 Likes
7 Replies
alevy
Specialist
Specialist
‎2013-06-06 11:16 PM

See http://docs.oracle.com/javase/6/docs/api/java/math/BigDecimal.html.
521 Views
0 Likes
Anonymous
Not applicable
‎2013-06-07 03:35 AM
Author

HI
You can use setScale() function for bigdecimal help u for rounding or setting the scale, below is the screen shot
thanks
Anil Kumar Burri
0683p000009MEct.png
521 Views
0 Likes
Anonymous
Not applicable
‎2013-06-20 12:56 AM
Author

Dear All, I am trying to read value of a column from a file. The value is something like this 3425876767642397. Yes such big number. I tried using long with length as 10. The job runs fine but the in the output it gives me some weird number and not the one from input. Pls advice whats the data type to be used for such huge numbers.
Regards
Sanjay
521 Views
0 Likes
Ashok_Panda
Contributor
Contributor
‎2014-03-24 11:53 AM

Hi All,
I am getting error "The operator + is undefined " in Talent tMap expression editor. Any operation i will do in the expression editor i am facing the same problem.I am using Developer version of Telend 5.4.
Can anybody suggest me what to do ?
Thanks
Ashok
521 Views
0 Likes
Anonymous
Not applicable
‎2014-03-24 11:19 PM
Author

Hi All,
I am getting error "The operator + is undefined " in Talent tMap expression editor. Any operation i will do in the expression editor i am facing the same problem.I am using Developer version of Telend 5.4.
Can anybody suggest me what to do ?
Thanks
Ashok

It is a Java compilation error, what's the data type of column? Can you please show us the expression?
Shong
521 Views
0 Likes
Anonymous
Not applicable
‎2016-02-07 01:38 AM
Author

 hii
I'm trying to perform arithmetic operation on one of my columns. when i compile i'm getting a java compilation error 
my column data type is BigDecimal. Someone please help me to solve this.
thankyou                                                                              0683p000009MEaK.png
521 Views
0 Likes
Anonymous
Not applicable
‎2016-07-11 04:19 PM
Author

 hii
I'm trying to perform arithmetic operation on one of my columns. when i compile i'm getting a java compilation error 
my column data type is BigDecimal. Someone please help me to solve this.
thankyou                                                                             

Hi Naveen
Are you able to resolve this issue
521 Views
0 Likes