Round down to 2 decimal place

Question & Answer
,
1

Hello everyone, i have a requirement where i need to round down to the 2 decimal place. For example, number like 0.128 will become 0.12 instead of 0.13.

Is there any work-around to make this possible in Quicksight? Please tell me, thank you.

2

Hi @Kuroha
i checked the function list but could found something.
But you could use a workaround:

parseDecimal(substring(toString(1.129),1,locate(toString(1.129),'.',1)+2))

BR

3 Likes
3

Hi @ErikG,
After testing around, I found another workaround solution basically like this:

floor(1.129*100)/100

I think it seems more optimal than parsing to string, what do you think?

4

HI @Kuroha
looks good.
BR

5

The solution provided by @ErikG , probably is the most robust way to solve it, worked for me, thank you @ErikG .