Count function and expression

[Anonymous]

Hello all,

I am finding some difficulty in using the count function, but using an expression to define what to count. Here is what I am trying to do:

=count({<left(aVar ,4)= {'Past'}>} aVar) / Count(aVar)

All I am trying to do with the above count is count only the variable that starts with the word "Past" and dividing it by the total count of the variable.

I get an error on the above statement and have no idea how to fix. Any help is much appreciated.

thank you

Roberto

[sunny_talwar · Accepted solution]

Is aVar a field or variable? If it is a field, try this

=Count({<aVar = {"Past*"}>} aVar)/Count(aVar)

[trdandamudi]

One more way may be as below:

=Count({<aVar= {"=Left(aVar ,4)= 'Past' "}>} aVar) / Count(aVar)