Hi All,
I have some sum() formulas in my powerapp which are adding up certain data around my app and displaying the results in a gallery.
All values are basically staff hours on a training program. So for example, some staff on a set training pathway have to gain 150 hours of experience.
What I would like to do is:
If the total hours equals less than 50% of 150 then the fill colour is RED
If the total hours equals 50% to 75% of 150 then the fill colour is ORANGE
If the total hours is over 75% and over of 150 then the fill colour is GREEN
I've had a look around and I cant find anything that I can use - anyone with any ideas?
