Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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