I have a key figure (plant capacity) that I have to display on a report. However, when I run the report, the capacity for each week in the month is adding up and the total is displayed. I however want the average of the capacity to show up. Eg- capacity is 500 tons per week, and for the month, I want to show 500 tons and not 2000 tons (as its happening now).
I changed the exception aggregation of the KF to Average of all values, reference characteristic Fiscal week. However it does not work.
Can anyone suggest what I need to do? Note I am running the report at Fiscal period level and fiscal week is not a characteristic on the report.