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.
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?
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!