Countif

[ByPA]

Hi,

I have 5 Text Input Control boxes, for which  I set the Format under Properties to be Numbers

I collected the values in a collection called "RecordYears"

If I create a context variable and Sum the NumClaims column, it is ok.

However, if I create a context variable and CountIf(RecordYears, NumClaims>0), I get an incompatible type error...

Since it is only 5 records, I don't think it is a delegation issue? How can I get countif to work?

Thanks for help!

[ByPA]

I stumbled upon a workaround...by adding "" before and after the 0 but it means that the value in the text input control is a text and not a number despite setting Format under Properties to be Numbers?

UpdateContext({CountTotal:CountIf(RecordYears,NumClaims<>"0")});

[Expiscornovus · Accepted solution]

Hi @ByPA,

As an alternative approach couldn't you convert the NumClaims to an integer by using a value function?

CountIf(RecordYears, Value(NumClaims) > 0)

[ByPA]

Hi Expiscornovus,

Thanks so much! Your suggestion is much better!