KPI Calculation

[#1]

For the Average DSI calculation (formula below works fine in the KPI Box, but not when I  break it up over any dimensions)

sum(

   aggr(

Sum({<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, report_metric_key={'4'}>}days_supply_inventory)

    * (sum({<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, report_metric_key={'6'}>}forecast)/

    Sum(TOTAL {<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, report_metric_key={'6'}>}forecast)),

    Category,supplying_plant_code_desc, [Material Code]

)

)

[#2]

[sunny_talwar]

Can you elaborate on which one is correct and which one isn't? May be provide a sample with expected output to help you quickly.

[#4]

Second one is correct Average should be 41.58. There are two dimensions Category and Plant Whse....without selecting any of the dimension KPI average is correct but when I select any of the two dimensions its incorrect.