When we creating a numeric field in a MDW table, TX suggets use a numeric(38,6) for the data type.
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/e8536935-6071-41b6-ad0d-356442a95301.png)
When the field it’s translated to the semantic model it’s detected in TX:
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/1ec21819-2886-44f9-9ae2-e2437539d2b0.png)
But in the model:
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/a110bc2f-ec77-4f96-931f-d60d8f49871e.png)
And one of the best practice rules says “Do not use floating point data types”.
How can I follow this rule?
Best answer by rory.smith
View original