Solved: Re: formatting numbers - Qlik Community

ali_hijazi · ‎2015-03-31

Hello

got values on a pivot table that are like:

1.498

1.491

what I want is display 2 decimal places but without rounding

I'm using the following format #,##.00

and I get for the above values 1.50

what I want is 1.49

is this possible?

I can walk on water when it freezes

PrashantSangle · ‎2015-03-31

Hi,

Try Floor(FieldName,0.01)

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2015-03-31

Hi,

Try Floor(FieldName,0.01)

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

fvelascog72 · ‎2015-03-31

Try this format:

#,##0.00

Report Inappropriate Content · ‎2015-03-31

Hi,

You can try this format.

#,##.##

Colin-Albert · ‎2015-03-31

You need to use a rounding function in you expression.

Round(number, precision) rounds the number up or down.

Floor(number, precision) rounds down

Ceil(number, precision) rounds up

The expression your need to use is Floor(YourValue, 0.01)