help with Aggr(Sum()

[RichardLee]

Hi Everyone,

I'm trying to work out the lodgic for what I think would be and Aggr(sum().

I have three items I need to group together for a single line and also work out the individual Cost of part of it.

Invoice Number	Invoiced £	FinalOrdersLive.Order Qty	ES	Order Value £	Order Value ES £
7054319	0	0	1	63	63
7054319	590	2	-	590	0
7054319	0	0	-	82	0

I need to group the Order Qty and the ES to a single line and divide the ES value by the Order Qty

So It will look like this

Invoice Number	Invoiced £	FinalOrdersLive.Order Qty	ES	Order Value £	Order Value ES £	ES Value
7054319	590	2	1	63	63	31.5

I need to do this as an Expression I can't alter the Data Load Script.

Thanks

[Frank_S]

Hi @RichardLee

What you need here is to edit your sheet and create a table chart and use measures (sum) to get your results.

However, your data is not accurate if you want to sum order value £. The actual sum of those 3 lines is 735. 

Everything else is correct.

Kind regards.

[RichardLee]

Thank you @Frank_S  my Data was accurate for my requirement, group the Order qty =2 and divide the ES value so the 82 should be ignored as no quantity purchased.