cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

How to count items in a datasource? CountIf?

I want to count all values in my column called SALDO but only count them if they Start with "-" not count them if they dont start with a minus sign.

 

So i have this huge list of numeric values

Some are positives and some are negatives. All negatives starts with a minus sign (-)

How to count all rows that start with a minus sign?

1 ACCEPTED SOLUTION

Accepted Solutions
Helper I
Helper I

Sounds like you've got the right idea.  throw in a "StartsWith" and you should get it all worked out.

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-counts

View solution in original post

1 REPLY 1
Helper I
Helper I

Sounds like you've got the right idea.  throw in a "StartsWith" and you should get it all worked out.

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-counts

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (17,853)