0 Replies Latest reply: Sep 27, 2016 1:07 PM by Jacob Wapinsky RSS

    Using Set Expression for Current month and last month data

    Jacob Wapinsky

      I am trying to use a set expression to calculate a yield percentage for a KPI for current month and prior month values.

       

      The expression I am trying to use for this is as follows

       

      Sum({1<Line={Line1, Line2, Line3},Process Month={Month(Today())}>} Yield output)

       

      I want the KPI to be fixed for a set number of lines for this month.

       

      Thank you!