1 Reply Latest reply: Oct 1, 2018 12:29 PM by Sunny Talwar RSS

    Using < or > in a Set Expression

    Jayme Knapp

      I'm trying to pull only transactions where the BackOrder Quantity is >=1..  Here is the expression I have so far, not sure how to use the >= expression.

       

      COUNT(

                     {$<[Transaction Order Status]={'Open'},

                          [Items Item Category]={'Catalog'},

                            [Transaction Type]={'Sales Order'},

                              [Transaction Line Backorder Flag]={1},

                                [Transaction Line Backorder Quantity] {'=> 1'}, 

                                  [Transaction Line Expected Ship Date]={'<$(=num(date(today()-1)))'}>}

         

          [Transaction Line Backorder Quantity]

      )

        • Re: Using < or > in a Set Expression
          Sunny Talwar

          May be try to place the = sign after < or > and add an equal sign after the field name you testing the condition against...

           

          COUNT(

                        {$<[Transaction Order Status]={'Open'},

                              [Items Item Category]={'Catalog'},

                                [Transaction Type]={'Sales Order'},

                                  [Transaction Line Backorder Flag]={1},

                                    [Transaction Line Backorder Quantity] = {">=1"},

                                      [Transaction Line Expected Ship Date]={'<$(=num(date(today()-1)))'}>}

           

              [Transaction Line Backorder Quantity]

          )