round Numbers to special format

[Anonymous]

Hi all,

I want to round results in my graph to a special format:

(sum(Erlöse) +10000 => 64.993,22

round(sum(Erlöse) +10000)  => 64.993

result wanted: 65.000

How do I get this?

Thank you for helping!

[Gysbert_Wassenaar · Accepted solution]

Try round(sum(Erlöse) +10000,100) or maybe round(sum(Erlöse) +10000,1000) if you want to round to thousands instead of hundreds.