I have a table containing SKU and quantities for a PO.
I want to create different scenario so the correct quantity figure is used.
Where the SKU appears once I want to the Quantity to show.
If the ITEM is repeated and committed quantity is null then I want to the Quantity only for the record where there is a value for quantity and committed quantity too. example SKUs where count=2 or can you use where record count is more than 1?
The column 'Figure to use' is the column I need to use. but I need to derive this. How do I do this? Can i compute this in script of use Set analysis in expressions?