Max comparing rows over several Dimensions

Fri, 19 Aug 2016 09:45:51 GMT

Hi together,

I have a simple question, but I can not find an easy solution to it.

I want to create a new field in the Load Editor, which gives me the Maximum of the row of 4 different dimensions:

No1	No2	No3	No4	Max(No1, No2, No3, No4)
1	2	3	4	4
6	7	8	9	9
9	8	7	6	9
7	2	8	2	8
4	5	3	2	5

Is there a function to create the column "Max(No1, No2, No3, No4)" or do I have to do this by using a lot of comparisions ?

Thanks in advance and best regards

Thorqlik

Re: Max comparing rows over several Dimensions

sunny_talwar — Fri, 19 Aug 2016 12:16:53 GMT

Try RangeMax() function instead of Max:

RangeMax(No1, No2, No3, No4)