Power Platform Community Forum Thread Details

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.

Categories:

Using Sum of a column to trigger true/false