This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

New doc: DECIMAL()

Posted on 08-01-2020 09:25 AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

At long last!

6 3 279
Topic Labels
3 REPLIES 3

Posted on --/--/---- --:-- AM
Grant_Stead
Silver 5
Silver 5
Reply posted on --/--/---- --:-- AM

Can we ROUND a decimal… like for accounting/prices…

i.e. a task worth $55.55 is 75% complete… what is the current earned value?
41.6625 is the answer… but we would expect this to be rounded to the nearest penny…

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to Grant_Stead
Reply posted on --/--/---- --:-- AM

There’s no function to round to a given decimal place, so you’ll have to apply some math:

(ROUND(41.6625 * 100) / 100.0)

Posted on --/--/---- --:-- AM
Grant_Stead
Silver 5
Silver 5
In response to Steve
Reply posted on --/--/---- --:-- AM

Thanks!
What i’m currently doing… Hard to keep up sometimes with expression tweaks…

Top Labels in this Space