Variance Analysis for Profit or Loss
Does anyone know how to create Variance analysis. I use reporting tool (Insert Calculations) but Varian (%) doesn't seem to work for all type of costs, for example revenue is favourable if actual revenue is higher than budget but if cost is higher it should be unfavourable. Variance % doesn't give the right calculation for costs and some KPIs. I used to create a module using Line Item Subset but percentage symbol was not shown and LIS doesn't look nice in Management Report.
Please advise the best way to fix this