You’re offline. This is a read only version of the page.
I need the users to be able to register any additional discount we might get on purchases that the company makes, so I have a unit price column and a additional discount column in my "Pricing" table.
The issue is, that dataverse doesnt have a "percentage" data type. Of course, people can use the decimal version, but the initial impulse when one is going to write down a discount is to use the percentage number.
Do I have to make a separate column that will take the discount percentage inputted by the user and transform it into decimal to avoid any mistakes, or is there a way for the same "additional discount" column to transform any data written in it to decimal (like how in excel when we set the format of a cell to percentage so any calculations done with that cell are accurate)
@danisername23 If the intention of the column is to for the value in it to be captured manually by the user, just use a Decimal/Whole Number type column (whatever fits your use case), and set the minimum and maximum values on it to be 0 and 100 respectively. You can then build logic in your application (or elsewhere) to interpret the value as a percentage for any calculations, reporting etc.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (