-1

Please help, I need to create a new formula field which should be the multiplication of a formula field by a percent field.

Formula field name is margin% - (Total_T_Price__c - Total_N_ Price__c ) / Total_Net_Price__c

Percent field name - Offerpercent

For both the above fields, the return type is percent and same for the new formula field. So I'm creating a new formula field as follows - margin% * offerpercent

But the new formula field is displaying as 0.00% even though there are values in the two fields being multiplied.

6
  • Did you try (temporarily) increasing the number of digits on the new field? That way you could check if there's anything being calculated behind the 2nd decimal. You might need to multiply both percentages with 100 before multiplying them. Oct 20, 2022 at 10:54
  • @GuyClairbois Thanks for your valuable time, I've tried multiplying both values with 100 but still not working. Oct 20, 2022 at 11:05
  • what if you put 1 single value in the new formula field? Either margin% or offerpercent. And see if any of those is 0. Oct 20, 2022 at 11:31
  • tried that if I put any single value, it shows that value in the formula field but when I try to multiply the formula field and % field then it's not showing any value. Oct 20, 2022 at 11:43
  • @GuyClairbois One of the fields offerpercent is showing values as 0 even tho it has 7.20 value Oct 20, 2022 at 12:03

1 Answer 1

1

According to me as formula field get calculated at the record load so it is causing issue.

What you can try is instead of referencing formula field in another formula field you can write both the formula again in third field.

For ex - Field A -> a1xb1 Field B --> c1xd1

You are doing Field C --> Field AxField B instead of this try a1xb1xc1xd1

Hope this helps you.

11
  • @prajjwalagarwal Could you please elaborate a bit more, I'm not able to understand, maybe if you can please explain using the fields I have provided in the question? Thanks for your valuable time. Oct 20, 2022 at 11:23
  • Formula for 3rd field will be -->( (Total_T_Price__c - Total_N_ Price__c ) / Total_Net_Price__c ) x offerpercent Not margin x offerpercent Oct 20, 2022 at 11:27
  • 1
    formula fields can have dependencies on each other. That should not be a problem. Oct 20, 2022 at 11:30
  • @prajjwal agarwal I tried that before, but it's not working. Oct 20, 2022 at 11:32
  • What is value of field margin% and offer % and what is type of 3rd field? Oct 20, 2022 at 11:35

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.