This content has been marked as final. Show 2 replies
I am looking for a function which allow me to identify the number of repitition of 3 in a value of field "Performance" also the value should not contains greater then 3 number. for example
Value 1: 000111122322232221111 3 IS REPETING MORE THEN 1 TIME SO RESULT SHOULD BE "NO"
Value 2: 000123456789999999999 VALUE CONTAIN GREATER THEN 3 VALUE SO RESULT SHOULD BE "NO"
Value 3: 000100000001222220001 RESULT IS "YES" AS THE VALUE DOES NOT CONTAIN GREATER THEN 3 NUMBER
Value 4: 000111112222223221121 SAME AS ABOVE RESULT SHOULD BE YES AS VALUE CONTAIN REPETITION OF 3 AT ONCE
Would appreciate your help on the above query