Age Count and Colour in PApps

[Sparky564]

I have created a gallery displaying personal data of employees. I would like two things to happen:

1. When the "Age" box is <=20 years old, it turns red.

The only code that works for me is:

If(ThisItem.Age = "20", red,white)

Obviously this code only captures those aged 20. Replacing the "=" with <= does not work. Any suggestions?

2. Count 

I want to use the count feature to count how many personnel are under 20. 

I tried CountIf(List,Age <="20") but this did not work. Any suggestions?

[Drrickryp · Accepted solution]

@Sparky564 

If your age value is text type you could try If(Value(ThisItem.Age)>=20, Red, White) and 

CountIf(List, Value(Age) <=20)

[Sparky564]

It works! Thank you very much