You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Rounding Formula Functionality

in Benefits 2 comments

Summary:

Hello. Can you do more than "Round" in a Rounding Fast Formula?

I have a requirement to first add a penny to a resulting rate calculation if result is odd. I'm certain we could handle this with a rate calculation formula, but the remainder of the rate calculation is handled perfectly via standard functionality.

I've tried a couple of approaches, including multiplying the input value (rate) by 100 to get a whole number and then using MOD to determine if odd or even. If odd, I am trying to add .01 to the formula input value (the calculated rate). The formula compiles successfully, but I'm not seeing the penny added as I'd hope.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!