13 Replies Latest reply: Sep 18, 2015 2:55 AM by Amit Saini RSS

    Script Help???

    Amit Saini

      Hi Folks ,

       

      Below is my expression :

       

      Sum({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)/if(Complaint_Type=3 or Complaint_Type=1, Sum (QTY_Delivered_TOTAL),if(Complaint_Type=2 or Complaint_Type=7, Sum (QTY_Received_TOTAL), 0))

      *1000000

       

      I'm calling a bar chart with Month as Dimension , but I'm getting "no data displayed value" when I'm calling above expression.

       

       

      Not sure If my expression is correct or not?

       

      Kindly suggest!

       

      Thanks

      AS