12 Replies Latest reply: Oct 15, 2015 7:29 AM by Amit Saini RSS

    Expression Help???

    Amit Saini

      Hi Folks ,

       

      Please see the attachment and suggest why below expression is not working for ABC Target values:

       

      if(GetFieldSelections(Major_Decfect_Grp_Cat)='Quality'

              , sum({1<Plant_Name ={'$(=getfieldselections(Region1))'}, Month -={'-'}>}[QDR Target])

              , if(getfieldselections(Major_Decfect_Grp_Cat)='Non-Quality'

                  ,sum({1<Plant_Name ={'$(=getfieldselections(Region1))'}, Month-={'-'}>}[QDR Target NQ])

                  , sum({1<Plant_Name ={'$(=getfieldselections(Region1))'}, Month-={'-'}>}[QDR Target NQ] + [QDR Target])

                  )

          )

       

      Thanks,

      AS