Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I show 2 Decimal points in .xls extract

Kinetic_analytics
11 - Bolide

Hello great minds:

Good afternoon. I want to show 2 decimal points in the output. I could see only 0.00. How can I solve this problem?

 

Total
-0.03

 

Thanks

8 REPLIES 8
Robin_McIntosh
11 - Bolide

A little more info?  Are you saying that the output of -0.03 is displaying as 0.00?

Kinetic_analytics
11 - Bolide

yes

Kinetic_analytics
11 - Bolide

I could see output like this:

 

Kinetic_analytics_0-1660845382261.png

 

Robin_McIntosh
11 - Bolide

Are you outputting to a template or a pre-formulated file in Excel?  Honestly, it's a bit hard to provide any real feedback with very minimal information such as the data you are working with, etc.

 

Kinetic_analytics
11 - Bolide

Kinetic_analytics_0-1660846437795.png

I have used this basic table tool. Did not configured anything. I do not know how to activate the grayed out Dec. Places

 

Kinetic_analytics
11 - Bolide
Robin_McIntosh
11 - Bolide

Glad you got it figured out.  Please remember in the future to provide as much information as you can in the beginning such as what tools you are using, what you've tried, etc.

 

Kinetic_analytics
11 - Bolide

For sure. Thanks

Labels