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.

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (3,659)