Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'm working with a file of purchase orders where I have all the line items for the purchase order, but each line one has the gross total of the Purchase Order.
I want to get to a situation where I have one purchase order and the total amount.
This is what I see:
PO ID Desc Total
12345 pencils 500.00
12345 pens 500.00
12345 garbage bags 500.00
65478 tickets 200.00
78963 computers 800.00
78963 software 800.00
This is what I want:
12345 500.00
65478 200.00
78963 800.00
Any help is appreciated!!!
May be this
Sum(Aggr(Amount, [PO ID]))
or
Sum(Aggr(Only(Amount), [PO ID]))
or
Sum(Aggr(Avg(Amount), [PO ID]))
or
Sum(Aggr(Sum(DISTINCT Amount), [PO ID]))
May be this
Sum(Aggr(Amount, [PO ID]))
or
Sum(Aggr(Only(Amount), [PO ID]))
or
Sum(Aggr(Avg(Amount), [PO ID]))
or
Sum(Aggr(Sum(DISTINCT Amount), [PO ID]))
Perfect, THANKS!!!!