Sign Up ›
  • kundan singh 52
  • NEWBIE
  • 0 Points
  • Member since 2020
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
3 replies

Unable to remove last 2 zero after decimal through formula field

Hi,

Just started learning salesforce stuck in 1 problem ..pls help!

i have a field having value ex
salary=2020.0000

trying to remove last 2 zero only..not able to achieve
want result like: 2020.00

want to use only "FORMULA FIELD"

tried through round() but its not working

 
3 replies

Unable to remove last 2 zero after decimal through formula field

Hi,

Just started learning salesforce stuck in 1 problem ..pls help!

i have a field having value ex
salary=2020.0000

trying to remove last 2 zero only..not able to achieve
want result like: 2020.00

want to use only "FORMULA FIELD"

tried through round() but its not working