RedditPP Mascot

RedditPP

r/tableau • … • u/ZaphodBeeblebrox

Different decimal place based on value not working as intended using ROUND function [see screenshot]

I was hoping to use a calculate field and round function so that values that are lower than 100000 using two decimal places and those above with 1. But the results I get are inconsistent as can be seen here. Any ideas what I am doing wrong?[See this ](https://freeimage.host/i/JUY8a2t)

— 0