Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Took over for somebody and am very new at this. The person left the company.
I seem to be fine when comparing alpha but am having trouble when it's a numeric column AND the issue might also be the GreaterThan sign.
I need to also include only items where the quantity is > 1000.
sum({<DNOY = {"<=$(=DayNumberOfYear(Today()))" },Year= {"$(=Max(Year))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Quantity Ordered] > 1000 , [Order Generation Number]= {0}, [Order Type] = {'O'}, [Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Shipped]) /
sum({<DNOY = {"<=$(=DayNumberOfYear(Today()))" },Year= {"$(=Max(Year))"} ,[Order Generation Number]= {0},[Drop Ship Code (Y or N)]= {'N'},[Order Type] = {'O'},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Ordered])
I think this will work:
[Quantity Ordered]={">1000"}
Regards,
Michael
The bold sytax doesn't seem to be working. I need to do one thing if the Item Class = 03 (which is an alpha field) and another if it doesn't equal 03. Sorry for the elementary questions but I've still not been to training and can't find any examples of how expression syntax works.
( sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {'03'}, [Quantity Ordered]={"<100000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Shipped]) +
sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {"<>03"}, [Quantity Ordered]={"<1000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Shipped])) /
( sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {'03'}, [Quantity Ordered]={"<100000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Ordered]) +
sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {"<>03"}, [Quantity Ordered]={"<1000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Ordered]))
The bold sytax doesn't seem to be working. I need to do one thing if the Item Class = 03 (which is an alpha field) and another if it doesn't equal 03. Sorry for the elementary questions but I've still not been to training and can't find any examples of how expression syntax works.
( sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {'03'}, [Quantity Ordered]={"<100000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Shipped]) +
sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {"<>03"}, [Quantity Ordered]={"<1000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Shipped])) /
( sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {'03'}, [Quantity Ordered]={"<100000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Ordered]) +
sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {"<>03"}, [Quantity Ordered]={"<1000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Ordered]))
The alpha comparison of 03 doesn't seem to be working. I need to do one thing if the Item Class = 03 (which is an alpha field) and another if it doesn't equal 03. Sorry for the elementary questions but I've still not been to training and can't find any examples of how expression syntax works.
[Item Class]= {"<>03}
The alpha comparison of 03 doesn't seem to be working. I need to do one thing if the Item Class = 03 (which is an alpha field) and another if it doesn't equal 03. Sorry for the elementary questions but I've still not been to training and can't find any examples of how expression syntax works.
[Item Class]= {"<>03"}
HI
[Item Class] -= {"03"}
This exclude the 03 value in it..
Hope it helps