I have something fairly bizarre and I'm fairly sure I'm missing something simple.
I have a Visible formula where it sums up the numerical(decimal places allowed) values of 4 fields. If the sum of 4 fields match, the error display is hidden. If it does not match, error display is shown. Here's an example.
Since Element K is input as $150.99 and it doesnt equal to $135.34, the error in red shows. If I fix the value of K, it'll behave as expected as shown here:
A user who was testing was able to find a combination where even though the validation should pass, it still throws up an error as if the rule is not matching.
It doesn't make sense that the above should still throw a validation error. Clearly the sum of fields G H I J matches the value of K but Powerapps sees it as a non-match. I thought having 0 as a value on some fields was the culprit but doesn't seem to be the case. From what I tested so far, doing whole numbers without decimals always works. Its some combinations that have decimal values that this seems to happen. Here are some other examples I found.
There are many combinations that work as well. I'm just not sure why there are a number of combinations where it doesnt work in the same space.
Below is my formula used on the Visible section to make this happen. Any insights anyone may have on what I'm missing here would be greatly appreciated!
If( IsBlank(P2P_Element_K_Value.Text) || Value(P2P_Element_K_Value.Text) <> Sum(Value(P2P_Element_G_Value.Text), Value(P2P_Element_H_Value.Text) ,Value(P2P_Element_I_Value.Text)
,Value(P2P_Element_J_Value.Text)), true, false)
