Aggregrate Functoid - MinStr

MinStr Aggregate Functoid

Description: The MinStr Aggregate Functoid will return the lowest alphanumeric value within the records provided to the input Field for the entire table or in case that a group functoid has been used the lowest alphanumeric value of the records within each group. Inputs with their allowed values:

Picture of the MinStr Aggregate Functoid

Remark: Important: The MinStr and MaxStr Functoids are dependent on country specific settings. This means that the use of a MinStr or MaxStr Functoid can yield different results in for example a French orientated environment (Language and Country settings) compared to an English oriented environment. This is because the values for characters can be denominated differently for each language set. Example: Example 1: Table with group by
Group By Values Result of MinStr
Group1 abcd abcd
Group1 Zz abcd
Group2 zZ 01234
Group2 01234 01234
See Figure 1.


Example 2: Table without group by
Group By Values Result of MinStr
None abcd 01234
None Zz 01234
None zZ 01234
None 01234 01234
See Figure 2.