Making a percentage column on a table

Like (0) Share

Report

Posted on 15 Dec 2023 12:28:31 by danisername23

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)

Categories:

Solution Explorer

Microsoft Dataverse

All responses (1)

Answers (1)

Verified answer

Parvez Ghumra 1,579 Super User 2025 Season 1 on 15 Dec 2023 at 12:40:02

Like (2)

Report

Re: Making a percentage column on a table

@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.