I’m trying to group in a GI by Lot/Serial Number for Stock Items, however, there are a few items without a serial number, and these are all being grouped together, despite being different lines (this is not a issue on Inventory Valuation for some reason.) Is there some way to do a conditional grouping? I tried =iif([InCostStatus.LotSerialNbr] <> ' ', [InCostStatus.LotSerialNbr], null) but the grouping happens even if the field is blank. Is there some way to do this?
Answer
Conditional Grouping in GI
Best answer by MichaelShirk
Maybe try this?
=iif([InCostStatus.LotSerialNbr] <> ' ', [InCostStatus.LotSerialNbr], CStr([InCostStatus.CostID]))
+5
=iif([InCostStatus.LotSerialNbr] <> ' ', [InCostStatus.LotSerialNbr], [InCostStatus.CostID])
If an IF statement works for grouping, this should do it since the CostID is a key field and will always be unique.
Michael Shirk, Pine View Buildings, LLC - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
=iif([InCostStatus.LotSerialNbr] <> ' ', [InCostStatus.LotSerialNbr], [InCostStatus.CostID])
If an IF statement works for grouping, this should do it since the CostID is a key field and will always be unique.
+5
Maybe try this?
=iif([InCostStatus.LotSerialNbr] <> ' ', [InCostStatus.LotSerialNbr], CStr([InCostStatus.CostID]))
Michael Shirk, Pine View Buildings, LLC - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.