Flow formula not computing correctly (is simple math)

Question

I have a simple math formula in my flow, the formula field is adjustedCost the body of the formula is...

{!$Record.Maximum_Bill_Rate__c} - {!profitDiscount} - {!profitDelta}

The data passed into the formula is: Maximum_Bill_Rate__c = 70 profitDiscount = .427 profitDelta = 15.67

Expected result: 53.90 Actual result: 86.24

Don't know why this is happening, seems like it should simply work.

Update: I have added a screen shot of the flow decision I added to show what the values are the formula is using...

Are those values what's displayed in the debug section of the flow, or just what you'd expect them to be? — Nicholas Savini, Commented Jun 8, 2021 at 16:36
are you sure you are looking at the currently activated version of the flow? — cropredy, Commented Jun 8, 2021 at 16:37
Seems like profitDiscount and profitDelta may be negative. — Adrian Larson, Commented Jun 8, 2021 at 16:37
see updated screen shot, is profitDelta negative since it has double parenths? — Bill Woodson, Commented Jun 8, 2021 at 16:53

Adrian Larson · Accepted Answer · 2021-06-08 18:42:44Z

1

You have negative values, so when you subtract them, it is effectively a sum of the absolute values.

answered Jun 8, 2021 at 18:42

Adrian Larson♦

151k38 gold badges247 silver badges431 bronze badges

Add a comment |

1 Answer 1