Rounding and data format problem

[DavidOliverChapman]

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:

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

The relevent incoming fields are Double, 8. 

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

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

[danilang · Accepted solution]

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