You’re offline. This is a read only version of the page.
76
Is there a way to create a calculated field that will give me the maximum value of four fields on the table (entity)? I have four fields, all defined as Whole Number fields, and I'd like to create a calculated field that will track the highest value entered in any of the four fields. In other words, the equivalent of the MAX(number1, [number2], ...) function in Excel. I know that I could create a Business Rule that would update a custom, Simple field type (not Calculated) Whole Number fields using a bunch of IF statements - OR - use JavaScript to do the same thing... But it seems like I should be able to do this with a calculated field. This is in Dynamics 365 online.
Hi,
Thank you for your query.
Currently, calculated fields do not support MAX function.
Only supported functions are:
ADDHOURS, ADDDAYS, ADDWEEKS, ADDMONTHS, ADDYEARS, SUBTRACTHOURS, SUBTRACTDAYS, SUBTRACTWEEKS, SUBTRACTMONTHS, SUBTRACTYEARS, DIFFINDAYS, DIFFINHOURS, DIFFINMINUTES, DIFFINMONTHS, DIFFINWEEKS, DIFFINYEARS, CONCAT, TRIMLEFT, and TRIMRIGHT.
Define calculated fields | Microsoft Docs
Apart from Business Rules, you can write a plugin to get the Max value.
Share
Report
All responses (
Answers (
