Workforce Compensation: Whether possible to round the compensation amount to nearest 5
Hi everyone,
We have a requirement from a client to round workforce compensation amounts to the nearest 5 (e.g., if the calculated amount is 1,232, it should round to 1,235; if it is 1,238, it should round to 1,240).
As you know, the standard Oracle Workforce Compensation plan currency and column properties offer rounding rules like "Round to nearest 1", "Round to nearest 10", "Round down", etc., but rounding to the nearest 5 is not natively supported out of the box.
Has anyone successfully implemented a workaround for this using either Dynamic Calculations or a Compensation Fast Formula attached to the worksheet column?
Any sample logic, mathematical tricks (e.g., dividing by 5, rounding to 0 decimals, then multiplying by 5), or configuration advice would be highly appreciated!Thanks in advance for your insights!