No, the first expression is for SALES QTY which is the units sold..
The second expression is for value but excluding VAT.
I gave both expressions as examples. So i need the set analysis from the first expression for it to show previous weeks but i need the second expression to give me the GP%. I don't need SALES QTY from the first expression.
Thanks for your reply...I was driving home from work earlier and thought to myself... "im sure the set analysis needs to be on each sum".. I will try that in the morning.
To answer your question on the sum for [Sales Value Ex VAT], i am not sure as this particular application was written by someone else. I am adding something to it that someone has asked for. All i do know is that it works spot on the way it is... but i will check tomorrow.