3 Replies Latest reply: Oct 18, 2016 1:32 PM by Bhawana Adhikari RSS

    KPI Calculation

    Bhawana Adhikari

       

      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]

       

      )

       

      )