Hi, I want to calculate a value using the RoundDown formula in MS Excel. For example if a measure has the value 9.91 I want to calculate the value 9. Can this be done in Phocas?

Yes, there is. Play around with this formula: ^Round({a},-3,1)

You can change what position you round to using the middle variable (-3 in example)

You can apply math to your calculation by adding a parenthesis grouping like this. ^Round(({a}*.2),-3,1)

I hope this helps, good luck.

2 Likes

Hi @Michael.A , thanks so much for this. I’ve just played around with it and got it to do exactly what I needed. You’re a legend! Thank You

1 Like