cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahhollan Helper IV
Helper IV

Countif issue - calculated field

I have a calculated field in a SharePoint list that calculates the number of days between an item submission date and the current date. it generates a number.  I'm trying to use countif in PowerApps to count all rows where the value is less than or equal to 5.  I keep getting the message that the formula is expecting a number. Here is my formula, CountIf('Alarm Tracking','Alarm Tracking'.'Days Old'<6), what am I doing wrong?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Countif issue - calculated field

Or try this: 

 

CountIf('Alarm Tracking',Value('Days Old')<6)

 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Countif issue - calculated field

 

deleted...

 

Super User
Super User

Re: Countif issue - calculated field

Or try this: 

 

CountIf('Alarm Tracking',Value('Days Old')<6)

 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

View solution in original post

Super User
Super User

Re: Countif issue - calculated field

Glad I could help! Good luck with the rest of the app! Feel free to reach out in case of any questions!

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,136)