What is the error in this expression?

[Anonymous]

HI All,

I am not able to figure out the issue with this expression:

=Count({<upper([Curr Status])={'MET'}>}Key)

Please help.

Thanks

Sam

[sunny_talwar]

You cannot use a function (Upper) before = in your set modifier.

You might want to do it in the script itself or use MET as it may be spelled in your database.

HTH

Best,

S

[maxgro]

maybe without set analysis

count(if(upper([Curr Status])='MET', Key))

[Anonymous]

I think that it is not case sensitive at all, that is there is no difference between

=Count({<[Curr Status]={'MET'}>}Key)

and

=Count({<[Curr Status]={'met'}>}Key)

[Oleg_Troyansky · Accepted solution]

And if you really want to insist on UPPER, you can do it like this:

=Count({<[Curr Status]={"=UPPER([Curr Status])='MET' "}>} Key)

[Anonymous]

Thanks all for your response!

[maxgro]

[Oleg_Troyansky]

You see Michael, it is case sensitive after all!

[Anonymous]

Thanks for testing!

[Anonymous]

I see, but it is very strange.  I'm just re-testing this simple expression:

count ({<Field={"*abc*"}>} Field)

and

count ({<Field={"*ABC*"}>} Field)

They return the same exact result.  The actual values in the Field are all capital.