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.
I have the below table and want to round Rent Balance to two decimal places and the result should match as in the Required column. I tried using the Round function but that does not give the desired result. Any ideas how I can use a formula or tool to achive this please.
Rounding is one of those things that sounds simple but can be complex because people mean different things when they say "rounding". Ken Black wrote a nice piece last year describing some of the different approaches and how to execute the rules in Alteryx:
FixedDecimal works well in a case like this. But what if you're bringing in a large amount of data with many columns that you want to cast as fixed decimal set to "8.3"?
In select, I can select multiple columns and change data type to FixedDecimal, but they will all be set to the default "19.2". Clicking the Size field and pasting or typing in "8.3" for every Column field gets tedious.
Is there a solution that would automate changing the data types of a large number of column fields to FixedDecimal set to "8.3"?