I want to create a basic formula to multiply one field by another. The only issue I have is one field is a formula field that I have rounded to the nearest whole number. However the results in the formula field still calculate the part numbers.

Example Wages: $701

Savings (Formula 25% of Wages):175 (decimal place = 0)

Weeks Savings Plan: 20

Total Savings(formula Savings__c * Weeks_savings_plan__c :3505

Although the figure is correct I would like the figure to be 3500 (20*175)

I've missed something off the formula. How do I get the formula to only use what is displayed in the box.

Thanks in advance

  • Are you storing the savings formula as a number or percent? – MANUELAN00 May 10 '16 at 3:53
  • @MANUELAN00 - A number – Quango Bruce May 10 '16 at 4:04
  • Can you post your formula please? – MANUELAN00 May 10 '16 at 4:07
  • Savings__c * Weeks_savings_plan__c *** Savings__c is a formula field but does not display decimal places - It is rounded to the nearest whole number. – Quango Bruce May 10 '16 at 4:14
  • The error should be in your Savings__c, can you post that one please? Depending on the type of formula a real value is stored but is shown different...If you post the formula I can help you with that... – MANUELAN00 May 10 '16 at 4:18

You have to update your formula Savings__c to FLOOR(Wages__c * 0.25). With this you will show and save the value round a number down (0).

Keep your formula Total Savings as it is and it should be fine.

Mark it as best answer if answered your question.



Total Savings = ROUND( Savings__c, 0) * Weeks_savings_plan__c

  • Thanks, This works also. I'll note them both down. Cheers – Quango Bruce May 10 '16 at 5:12

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.