Sharepoint计算列-5个字段中的最大值并显示文本 [英] Sharepoint Calculated Column - Max Value across 5 fields and displaying Text

问题描述

嗨.

我需要查看5个字段，以识别其中的最大值

I have 5 fields I need to look at to identify the highest value across the them

一旦我获得了最高的价值，我就需要知道它来自哪一列，这样我就可以显示列的字段名称或适当的文本来标识它.

Once I have the highest value, I then need to know which column it came from so I can display the column field name or an appropriate text to identify it.

非常感谢您在此选项中使用的有关公式的任何建议.

Would appreciate any suggestions on the formula to use in this option.

示例:-

Field_A-值为100

Field_A - Value is 100

Field_B-值为150

Field_B - Value is 150

Field_C-值为90

Field_C - Value is 90

Field_D-值为85

Field_D - Value is 85

Field_E-值为300

Field_E - Value is 300

-

Field_E是最高的，因此在这种情况下，我需要显示文本Field_E.

Field_E is the highest, so I need to display the text Field_E in this scenario.

谢谢

推荐答案

所有提到的字段都是数字类型(Field_A，Field_B，Field_C，Field_D，Field_E).

All the mentioned Fields are number type ( Field_A ,Field_B ,Field_C,Field_D,Field_E) .

创建一个计算字段，公式将为 = MAX(Field_A，Field_B，Field_C，Field_D，Field_E)

Create a calculate field and the formula will be   =MAX(Field_A ,Field_B ,Field_C,Field_D,Field_E)

这篇关于Sharepoint计算列-5个字段中的最大值并显示文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！