How does Max function works?

[Former Member]

How do Max function work with strings? I can´t understand it.

We have the following strings but I don't understand why Webintelligence keeps marking 1:58 as the max string? If clearly 13: is the max string

Isn´t 3 > :

?

how does max fucntion evaluate special characters versus numbers? which one is bigger? In the first section you can see that 1: > 1:

[arijit_das · Accepted solution]

Found one SAP KBA explaining sort algorithm used in WebI.

According to SAP Note 1297677 :

Business Objects uses the ISO/IEC 14651 standard to sort data. This ISO/IEC Standard is aligned with the Unicode Collation Algorithm (UCA) specified in Unicode Technical Standard #10. Special characters and spaces in front of or in the middle of other characters will be disregarded, and the data will be sorted alphanumerically.

[Former Member · Accepted solution]

Thanks Arijit. It explains it all.

[Former Member]

hi

refer the below link:

http://www.youtube.com/watch?v=WvbPqbRS8ho

mark helpful if it helps you thanks

regards

[arijit_das]

Looks like while ranking or calculating max/min webi considers ":" character and other special characters as some kind of separators and first the strings at left side of the separator are compared and then the right part. Ascii of : is 58 where ascii of 3 is 51. But I have seen webi does not rank by ascii always. I am yet to figure out the exact logic it uses.