limited rounding

[Anonymous]

Hi everybody!

I need to round numbers by the 19th decimal place.

In the menu of QlikView there is a possibility to round by the 14th place.

To round within the script or in a table didn't work with these numbers.

I think it will work with an if-loop, but that will only work exactly by a

repeat of a querry for each decimal place.

Somebody with an equal problem or a simpler answer?

Have a nice weekend!

[Clever_Anjos]

Yes,

Are you using a SQL SELECT or a procedure that has a SQL SELECT within ritgh?

So try something like

SELECT

     myfield/1000000 as myFieldTransformed

    [other fields]

FROM mytable;

[petter]

Which system does the 19 decimal numbers come from? What data type is it? If there is indeed a super high-precision floating point or decimal type of number it should be quite easy to round it by trying to get it in as a text string and then just pulling out the last few digits and based on a simple if round it to 14 digits floating point precision.

Going via any number format in QlikView and dividing or multiplying from that will never work as long as you try to treat the number as a single entity.

If you give us information on where the numbers come from. A SQL database? A CSV-file / Text-file or something? We could be able to give you better suggestions or solutions....