Averaging a fixed decimal

Question

Hi,

I am attempting to summarize and average a fixed decimal with multiple decimal points (less than 1). Using a fixed decimal with precision of 22 and scale of 10. I am averaging ignore 0s.

When I summarize the value and average, I lose all decimal places in 2 of the fields. Any ideas why and any idea how to summarize and get more than ._ after?

AngelosPachis · Answer

Hi @eisesara ,

I believe that happens because 0.5 is a rounded number and Alteryx just gets rid of the extra 0s, well because they are zero and for a numerical value they don't really matter.

You can put the 0s back there if you convert each of your columns into a string data type, and then use a padright formula to pad each cell with zeros

So that expression means that the string field should have 9 characters in length, and pad it with 0s to the right, until that number of characters is achieved.

Hope that helps,

Angelos

example.yxmd