1 Reply Latest reply: Mar 3, 2016 12:59 PM by Sunny Talwar RSS

    Set Analysis without variables

    Taylan Karaarslan

      Hello all,


      I'm trying to create a set analysis equivalent to this expression that I use in a pivot table's expression column:


      SUM(

                IF

                     (

                          ISSUE_DATE >= SHIPMENT_DATE

                          AND ISSUE_DATE < NEXT_SHIPMENT_DATE

                          AND CHECKED_SHIPMENTS=1,

                          SHIPMENT_VALUE

                     )

           )

       

      I've already checked through community a lot but so far I could only found set analysis solutions with variables.
      Since I'm not very familiar with set analysis syntax, I couldn't manage to create a working expression.
      The expression above works fine but I want to write it as a set analysis expression due to better performance.
      In my case ISSUE_DATE, SHIPMENT_DATE and NEXT_SHIPMENT_DATE fields are all in the same date format.
      I'd appreciate any help.
      Thanks in advance,