New doc: DECIMAL()

At long last!

5 Likes

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…

2 Likes

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)
4 Likes

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

5 Likes