+1Is something like this possible? I wanted to avoid excel by making a calculated field that summarizes a single or group of inventory IDs through GI or report designer. So a calculated field would look like this...
=IIf((( [POLine.InventoryID] = 'DULS001') OR ([POLine.InventoryID] = 'DULS002')), [POLine.LineAmt], '')
Results would look like this...
| Calculated Field | Calculated Field | ||
| Inventory ID | Line Amt | Dulse | Kelp |
| DULS001 | 200 | 200 | |
| KELP001 | 500 | 500 | |
| DULS002 | 300 | 300 |
Best answer by BenjaminCrisman
Hi
There won’t be a way to SUM all the lines unless it’s grouped I suspect, unless you create a SQL view which already SUMS these, then this could be displayed instead of a calculation.
But your calculation should work based on the way it looks.
I did a quick mock up using SOOrder and Order Type and found it looks exactly like you’re showing:
=IIF([SOOrder.OrderType]= 'CS' OR [SOOrder.OrderType]='IN', CStr([SOOrder.CuryOrderTotal]), '')
Again though, if you are wanting a summary of these amounts you’ll need to group by the Order Nbr or Inventory ID maybe
+4Hi
There won’t be a way to SUM all the lines unless it’s grouped I suspect, unless you create a SQL view which already SUMS these, then this could be displayed instead of a calculation.
But your calculation should work based on the way it looks.
I did a quick mock up using SOOrder and Order Type and found it looks exactly like you’re showing:
=IIF([SOOrder.OrderType]= 'CS' OR [SOOrder.OrderType]='IN', CStr([SOOrder.CuryOrderTotal]), '')
Again though, if you are wanting a summary of these amounts you’ll need to group by the Order Nbr or Inventory ID maybe
+1I was having a bad day when I wrote this apparently. Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.