How to fetch decimal values of the calculation done in JRS report
Hello All,
I am creating a report where i am doing a mathematical calculation in advanced query of a JRS (DW ) report. I have tried using Decimal(value,4), float to get the decimal value result of the calculation done. But I am unable to get the decimal values (i.e., it is showing 3.00 instead of showing 3.42 ). Or is it a known issue in JRS?
Help on this query is very much appreciated.
One answer
From my experience, the floating point data type in DNG is quite low precision (although not as low as you seem to have in your question!). In several cases I ended up using a String and then converting it to a float value.
Either way, the floating point arithmetic, what functions are available, and their precision is a function of the back end database you're using.
If this is a DB2 back end database then the DECIMAL function is actually used to convert data into a fixed point value and it takes three arguments - DECIMAL(value, <precision, <scale>), where precision is the total number of digits in the result, and scale is the number of decimal places, so your function should really be DECIMAL(value, 3, 2) - leaving out the last parameter sets it to zero, so you get 3 digits and no decimal places