Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I have the attached QVW, the aggregation did work but ive had to make a change to the a variable that is uses in a number of the expressions and since the change the aggregation has stopped working.
The variable that i have changed is vAvgPrice, which is the first variable in the variable overview.
the variable used to be a division of sales \ qty. which gave an avg price. now the avg price is provided to me via an excel sheet, so i have changed the variable to use this instead.
the excel sheet (also attached) has an average price by product and customer, so there would be multiple entries for each item as the price by customer differs.
Can anyone help me getting the aggregation to work.
an example of an item number is 05842 and a customer (which is selected and locked anywway) is Qnivd.
The annual sales for this should be 1,452,071.61 which works when the item is selected, but when unselected it shows as 1,210,503.69
(it is the top row).
any help would be great.
What if you just use [Avg Price] for vAvgPrice variable
bloody hell! i cant believe it was that easy!!!
Thanks Sunny!