Calculated field - Max function?

(0) Share

Report

Posted on by ScheumanRJ

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.

All responses (1)

Answers (1)

Verified answer

Wahaj Rashid 11,321 on at

Like (1)

Report

RE: Calculated field - Max function?

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.