Choosing the right Data Type for a Field is a very important step, because it determines the kind of data that will be stored and how it’s handled inside the system.
Let’s look at 4 of the most common Data Types used in Dynamics 365 CRM: 🔢 Whole Number, 📈 Floating Point Number, 🎯 Decimal Number, 🆔 Auto Number
🔢 Whole Number: used to store whole numbers only (no decimal fractions). Uses: number of customers, number of orders, number of products. Examples: 10, 50, 100.
📈 Floating Point Number: used to store numbers with decimal fractions, with the ability to perform calculations on them. Uses: measurements, weights, distances. Examples: 10.75, 25.63. Suitable for data whose precision might shift during calculations.
- 🎯 Decimal Number: used to store decimal numbers with higher precision compared to Floating Point Number.
🆔 Auto Number: a sequential number automatically generated for every new record.