In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Rounding and data format problem

DavidOliverChapman
7 - Meteor

Dear team,

 

I have a workflow which takes some external (third party) data and adds various "in house" categories and groupings.

 

In the incoming data are property transaction prices:

 

clipboard_image_1.png

 

In order to add various groupings, I have a formula to create a new column, taking the price and diving by 1000000:

 

clipboard_image_2.png

 

 

The relevent incoming fields are Double, 8. 

 

Problem: in the output, these fields are being rounded to a whole number:

 

clipboard_image_3.png

 

Ideally, it would be good to have this set to 4/5 decimal places.

 

I did have a data cleansing tile and auto field following the formula, but I have deactivated these.

 

Any thoughts on what I am doing wrong?

 

Best


David

1 REPLY 1
danilang
19 - Altair
19 - Altair

hi @DavidOliverChapman 

 

A few ways to help you narrow down where the issue may be occurring 

 

  • Check the results in a browse tool just before your output
  • Check the formatting in the output excel sheet to ensure that the cells are not set to 0 decimals
  • Write the results to a .csv and check the results there. 

Dan

Labels
Top Solution Authors