Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
)
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]
)