Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Pick( _%TransactionType, $(expFilteredPlannedReceiptQty), $(expFilteredMaterialRequirementQty), Null())
This is the code. I attached a screenshot of the error. The variables don't seem to have any errors.
expFilteredPlannedReceiptQty = Sum({<[_GeneratedRow]={0},%MRPTransactionType={1},%MRPOrderType={"*"}-{"$(vIncludeMRPOrders)"},[MRP Transaction Date]={"<$(vMaxTransactionDate)"}>} [MRP Movement Qty])
expFilteredMaterialRequirementQty = Sum({<[_GeneratedRow]={0},%MRPTransactionType={2},[MRP Transaction Date]={"<$(vMaxTransactionDate)"}>} [MRP Movement Qty])
Can anyone tell me what's wrong with the syntax here?