I have created a variance analysis without using a version and instead using a line item subset. In the attached snapshot, Revenue, Gross Margin, and GM as a % of Revenue all belong to a P&L Line item subset and Actuals, Prior Year, and Versus Prior Year (VPY) are line items in the module. In the module in which they originated GM as % of Revenue is a line item formatted as a number percentage. However, when including GM as % of Revenue as a line item subset, the % sign does not carry through which we need for reporting.
Does anyone know how to make the % sign flow through?