This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If you use the round function, rounding to nearest 100 and the result is less than the original number then add 100 and round it. Otherwise, if the rounding was more than the original number then keep that rounding.
Maximum of round to nearest 100 and add 49 and then round to nearest 100. Both get same results.
Round up to next integer the result of field1 divided by 100 and multiply that number by 100. All 3 get same results.
Seems to work for me.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return. Please Subscribe to my youTube channel.