Fixed Decimals for IRR calcuatlon, displaying to 6 decimals only

[wonka1234]

Hi,

I am doing a summarize tool for IRR. However it is just rounding to 6 decimal places.

Is there a workaround to show more decimals?

heres some of my data before summary tool:

hres the sumamry:

I would like to have more decimals in this summary.

[MilindG]

What if you use formula tool and create new column = current column and change the fixed data type (Scale) to however many decimals you need.

[DataNath]

If you go to the metadata, what is the data type? I’m not 100% sure on the Summarize behaviour but it may be that the tool is converting the output to a double automatically. Perhaps you just need to add a select tool afterwards and convert it back to the level of detail of your choosing? As a default Alteryx uses 6 but you can just change this in the select.

[DataNath]

*can’t edit comment*

Meant to add that you’d use a select to change it back to a FixedDecimal.

[IraWatt]

Hey @wonka1234,

There is probably not any rounding happening if your column is a double you have 15 digits of precision. The 6 digits are just visual formatting.

Data Types | Alteryx Help 

[wonka1234]

hi all, tried all the suggestions. Looks like the summary tool automatially makes it a double regardless of my input!

[IraWatt]

@wonka1234 Double has the highest precision of any numeric data type in Alteryx - Data Types | Alteryx Help It is not 6 digits it is 15 as I wrote above

[wonka1234]

In excel im getting an IRR of 

0.00295306660687578

but using fixed decimal / double im getting just 0.002953

[IraWatt]

@wonka1234  I just tried with the formula it also seems to round to 6 decimal places 

[wonka1234]

@IraWatt  thanks. Do you know if there is a way to show more? 

I think it just rounds upon reading it in.

I see the msg  

Display value was rounded to 6 decimal places error

Not sure if that can be changed to read it more then 6. That seems to be the issue