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... enter image description here

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.