Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
)
)
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.
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.