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
