Right function returns incorrect results.

[nancymarmat]

I am trying to filter results in a chart to count the number of items that DO NOT end with the character 'S'.

The expression I am using is: =IF(right(LineItemNumber,1) <>'S',  TextCount(distinct LineItemNumber))

The results count all items.

What is wrong with the syntax?

Thank you.

[sunny_talwar · Accepted solution]

May be try this:

TextCount(DISTINCT {<LineItemNumber -= {'*S'}>} LineItemNumber)

or

TextCount(DISTINCT If(WildMatch(LineItemNumber,'*S'), LineItemNumber))

[nancymarmat]

Thank you.  That worked!