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!
Solved! Go to 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)
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")});
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)
Hi Expiscornovus,
Thanks so much! Your suggestion is much better!
User | Count |
---|---|
260 | |
110 | |
98 | |
56 | |
40 |