9 Replies Latest reply: Dec 5, 2017 1:16 AM by Amit Saini RSS

    Set Analysis include values

    Amit Saini

      Hi Folks,

       

      Below is my scenario:

       

      In Text box for Output '11611' I'm calling below expression:

       

      =num(sum({$<Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

       

      Now what I'm looking for is that Output should remain always 11611 even if any users are selecting or filtering the data based on "Standard_Name" (Should includes all values)

       

      I'm trying below expression , but it not working:

       

      =num(sum({$<Standard_Name=,Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

       

      Or

       

      =num(sum({$<Standard_Name=p(Standard_Name),Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

       

      Please suggest what should be right logic.

       

      Regards,

      AS