topic Re: Max of Multiple fields in a table in Connectivity & Data Prep

Max of Multiple fields in a table

Anonymous — Fri, 02 Apr 2021 08:09:13 GMT

Hi,

I am trying to get the maximum values for multiple fields is a table and display it in KPI.

for example : I have fields F1, F2, F3

F1 has values--> 1,3,4

F2 has values--> 1,2,3

F3 has values--> 2,3,4

so in this case KPI would show the maximum total of the 3 fields which is 9

can anyone please help.

Thank you.

sunny_talwar — Thu, 14 Sep 2017 18:21:49 GMT

May be this

Sum(RangeMax(F1, F2, F3))

its_anandrjs — Thu, 14 Sep 2017 18:34:49 GMT

How it should be 9 can you explain this please for understanding. Will it be maximum values for all three fields that is (3+3+3).

Anonymous — Thu, 14 Sep 2017 18:40:15 GMT

F1=1+2+4

F2=1+2+3

F3=2+3+4

the sum of F3 is the maximum this is what I want to show

sunny_talwar — Thu, 14 Sep 2017 18:48:19 GMT

May be this

RangeMax(Sum(F1), Sum(F2), Sum(F3))

maxgro — Thu, 14 Sep 2017 18:48:32 GMT

rangemax(sum(F1),sum(F2),sum(F3))

its_anandrjs — Thu, 14 Sep 2017 18:54:59 GMT

Where you want to use this expression.

Anonymous — Thu, 14 Sep 2017 18:56:44 GMT

Thank a lot this worked

Anonymous — Thu, 14 Sep 2017 18:57:10 GMT

Thanks a lot this worked

its_anandrjs — Thu, 14 Sep 2017 19:00:34 GMT

They are individual fields then try only this expression in any text object or the KPI object

=RangeMax(Sum(F1), Sum(F2), Sum(F3))

=Sum(RangeMax(F1, F2, F3))