cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Humanity
Helper V
Helper V

Using Sum of a column to trigger true/false

This formula works to generate a total in a Text box.

Sum('Natural Gas Bills',Progress)

 

However this below is giving me an error?

If(Sum('Natural Gas Bills',Progress)="100",true,false)

 

Warning: Incompatible type.  We can't evaluate your formula because the values being compared in the formula aren't the same type.

1 ACCEPTED SOLUTION

Accepted Solutions
Humanity
Helper V
Helper V

Erasing the quotations around 100 solves it.

View solution in original post

1 REPLY 1
Humanity
Helper V
Helper V

Erasing the quotations around 100 solves it.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (962)