Display Percentage Values Correctly
Percentages are a classic gotcha when Workday OfficeConnect’s default Thousands rounding interacts with Adaptive Planning values stored as decimals. Before changing settings, review where rounding is configured in Change Rounding Settings so you fix the right level.
Problem: Percentage values from Adaptive Planning appear as tiny decimals in OfficeConnect. For example, 25.25% shows as 0.0002525 when workbook rounding is set to Thousands.
This happens because OfficeConnect stores percentages as decimals (0.2525) and then applies the workbook’s rounding setting on top — Thousands rounding divides by 1,000, making it 0.0002525.
Fix option 1: Set rounding to No Rounding (whole workbook)
Trade-off: This removes rounding from the entire workbook. All other numbers will display without rounding too.
Fix option 2: Suppress rounding on specific cells only
% button).Advantage: The rest of the workbook keeps its rounding. Only the percentage cells display without rounding.
Next steps
- Change Rounding Settings to adjust workbook- or user-level rounding defaults
- Workbook & Worksheet Properties for the rest of the format controls
- Build a Budget vs. Actuals Variance Report for a worked example mixing percentages and currency amounts