hi guys
I am attaching a qvw here which has many calculations,i am finding a very strange thing here or maybe i just never experienced it before.
there are 2 columns named Qty here one is in dimension which is just qty and other is sum(qty) in expressions.I verified this column and the column qty which is in expressions as sum(qty) seems to be correct when matched with sources.All my other values also are matching such as Primary frt,alloc Primary frt,sec frt,alloc sec frt.
Now here is the strange thing as soon as i remove the Qty column(because I dont need it anymore) from dimensions which is just qty not the sum all the other values change and these are no more correct.
One more thing Primary frt is using the qty and it is coming correct even after removing the qty column and Alloc primary frt is using primary frt to get the value.if primary frt is correct so should Alloc prim frt.
And why is this even happening after removing the qty column?
Any suggestions or help ?
Urgent solution required.
