I am an OAC Developer working with the State of North Carolina and have encountered an issue in the comparative reports related to the Percentage Change column.
We have developed reports to present a comparative view between the current year and the prior year, including the percentage changes for various accounts. However, when the sub-totals are applied to these accounts, the percentage values are incorrectly aggregated instead of being recalculated accurately at the subtotal and total levels.
Additionally, some accounts involve sign adjustments, which further impact the correctness of the percentage calculations.
The expected behavior is for percentage changes at subtotal and total levels to be compared correctly-consistent with how they are calculated in ERP reports.
We request an enhancement to ensure that percentage change calculations for totals and subtotals are handled correctly and align with stansard ERP reporting logic.