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.
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.
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.
*can’t edit comment*
Meant to add that you’d use a select to change it back to a FixedDecimal.
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.
hi all, tried all the suggestions. Looks like the summary tool automatially makes it a double regardless of my input!
@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
In excel im getting an IRR of
0.00295306660687578 |
but using fixed decimal / double im getting just 0.002953
@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