+ Start a Discussion

IF formula error

We have created a simple IF formula within Flow.:


IF (A = (B-C),1,0)


This seems to work but not consistently. All three values are pulled from a custom object and based on roll-up summaries. 


I have looked at every angle and cannot see any possible reason for the failed calculations to not work. 


I replaced the IF equation with a decision: IF A = Formula for (B-C). This works fine. 


Has anyone else experienced these types of inconsistency in using IF formulas? I dont see why the IF formula would fail but a decision element work on the same equation. 




Try including condition in paranthesis:


IF ((A = (B-C)),1,0)


or take value of B-C in a variable and then use it in IF.