Announcements
Hi,
For one of my entities at Dataverse I want to create a calculated column that is calculated with a formula that need to use other fields values (decimals). During the creation of calculated field I am not able to select numeric values which is strange. I have them implemented it as a normal field using a business rule but here I have another problem: Formulas are very simple and you have to insert several action components to calculate a simple formula. For example to calculate field 3 = (field1/field2-1)*100 I had to create the actions.
Is that normal or I am missing something?
Hi @PowerPedro,
Possible to elaborate on the exact data types of these fields you are trying to calculate? Also the exact error message? In general, the formula you paste is doable with calculable fields, but field1 and field2 needs to be the same data type (can't mix strings with numerics)...
Cheers
You are right. In some of the fields I did not have the same type. Now with all the fields of type decimal it works. thanks.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
