num(
round(
  if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct Market) = 1
      // one market
      , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [Delivery Model]) = 1
          , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct Category) = 1
          	, if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
            	, sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                	sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                	, Month, Market, Business, Category, [S&OP Order aggr]))
                  / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])

            	, sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                )

            , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                    if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            , Market, Business, Category, [S&OP Order aggr]))
                            / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                            , Month, Market, Business, Category)) 
                        /
                        sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

                    , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [ZPO_ZSO Order aggr]) > 1
                        ,   (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                                , Month, Market, Business, [ZPO_ZSO Order aggr]))
                            /  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                            )

                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                    ))
                  * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                  , Month, Market, Business))
                  /
                  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
          )

          , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(

               sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                    if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            , Market, Business, Category, [S&OP Order aggr]))
                            / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                            , Month, Market, Business, Category)) 
                        /
                        sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

                    , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [ZPO_ZSO Order aggr]) > 1
                        ,   (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                                , Month, Market, Business, [ZPO_ZSO Order aggr]))
                            /  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                            )

                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                    ))
                  * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                  , Month, Market, Business))

                , Month, Market, [Delivery Model]))
              / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
      )

  , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [Mega Market]) = 1
      // one market
      , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [Delivery Model]) = 1
          , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct Category) = 1
          	, if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
            	, sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                	sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                	, Month, [Mega Market], Market, Business, Category, [S&OP Order aggr]))
                  / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])

            	, sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                )

            , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                    if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            , Month, [Mega Market], Market, Business, Category, [S&OP Order aggr]))
                            / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                            , Month, [Mega Market], Market, Business, Category)) 
                        /
                        sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

                    , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [ZPO_ZSO Order aggr]) > 1
                        ,   (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                                , Month, [Mega Market], Market, Business, [ZPO_ZSO Order aggr]))
                            /  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                            )

                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                    ))
                  * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                  , Month, [Mega Market], Market, Business))
                  /
                  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
          )

          , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(

               sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                    if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            , Month, [Mega Market], Market, Business, Category, [S&OP Order aggr]))
                            / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                            , Month, [Mega Market], Market, Business, Category)) 
                        /
                        sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

                    , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [ZPO_ZSO Order aggr]) > 1
                        ,   (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                                , Month, [Mega Market], Market, Business, [ZPO_ZSO Order aggr]))
                            /  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                            )

                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                    ))
                  * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                  , Month, [Mega Market], Market, Business))

                , Month, Market, [Delivery Model]))
              / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
      )

  , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [Market Cluster]) = 1
      // one market
      , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [Delivery Model]) = 1
          , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct Category) = 1
          	, if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
            	, sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                	sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                	, Month, [Market Cluster], Market, Business, Category, [S&OP Order aggr]))
                  / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])

            	, sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                )

            , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                    if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            , Month, [Market Cluster], Market, Business, Category, [S&OP Order aggr]))
                            / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                            , Month, [Market Cluster], Market, Business, Category)) 
                        /
                        sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

                    , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [ZPO_ZSO Order aggr]) > 1
                        ,   (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                                , Month, [Market Cluster], Market, Business, [ZPO_ZSO Order aggr]))
                            /  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                            )

                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                    ))
                  * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                  , Month, [Market Cluster], Market, Business))
                  /
                  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
          )

          , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(

               sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                    if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            , Month, [Market Cluster], Market, Business, Category, [S&OP Order aggr]))
                            / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                            , Month, [Market Cluster], Market, Business, Category)) 
                        /
                        sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

                    , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [ZPO_ZSO Order aggr]) > 1
                        ,   (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                                , Month, [Market Cluster], Market, Business, [ZPO_ZSO Order aggr]))
                            /  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                            )

                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                    ))
                  * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                  , Month, [Market Cluster], Market, Business))

                , Month, [Market Cluster], Market, [Delivery Model]))
              / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
      )

      // multiple markets
      , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [Delivery Model]) = 1
          , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct Category) = 1

            , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
            	, sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                	(
                    sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                	sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                     , Month , Market, Business, Category, [S&OP Order aggr]))
                    / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                    ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                    , Month, Market, Business, Category)) 
                  /
                  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

            	, sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                )

            , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                  
                  if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
                    , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            , Month, Market, Business, Category, [S&OP Order aggr]))
                            / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                        , Month, Market, Business, Category)) 
                        /
                        sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

                    , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [ZPO_ZSO Order aggr]) > 1
                        ,   (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                                , Month, Market, Business, [ZPO_ZSO Order aggr]))
                            /  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                            )

                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                        )
                    )
                   * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                  , Month, Market, Business))
                  /
                  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
          )

          , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(

                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                  
                  if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [S&OP Order aggr]) > 1
                    , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            , Month, Market, Business, Category, [S&OP Order aggr]))
                            / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# SOP_nonSOP_Weight])
                            ) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                        , Month, Market, Business, Category)) 
                        /
                        sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

                    , if(count({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>} distinct [ZPO_ZSO Order aggr]) > 1
                        ,   (
                            sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}aggr(
                                sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines) * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                                , Month, Market, Business, [ZPO_ZSO Order aggr]))
                            /  sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# HPM_ZSO_ZPO_Weight])
                            )

                        , sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR) / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}#OTTR_valid_lines)
                        )
                    )
                   * sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])
                  , Month, Market, Business))

                , Month, [Delivery Model]))
              / sum({<Year =, Month=, %Date.KEY = {">=$(vCurrentYear)0000<=$(vCurrentPeriod)"}>}[# AOP])

      )
  )))
,0.001)
, '#,##0.0%'
)