Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV-Designers,
I want to calculate the ratio of the discount per "employee"
therefore i use the expression:
SUM ( { <TypeOfVoucher={'Sale'} , DiscountID = {'Reduction'} >} AmoutOfDiscount
These expression works fine.
I want to divide the mentioned expression by the total amount of discount of the store,
but i dont know how to handle this.
Thanks in advance for any help.
so long
daniel
Hi Joe,
the diagramm is a "pivot table"
so that the empolyee-number, shop-number and a time-scale is used to creat this "pivot".
But I want to show a ratio of the "reduction per employee in relation to the total reduction of the whole shop".
greets
daniel
Hi Daniel,
that is what I thought, you will still need to put the employee-number in your set analysis in order to get the correct total, as it stands if you don't put that extra set analysis in the total part of your expression it won't know to ignore the employee-number and so give you the wrong total
SUM ( { <TypeOfVoucher={'Sale'} , DiscountID = {'Reduction'} >} AmoutOfDiscount) /
SUM ( { <TypeOfVoucher={'Sale'} ,[employee-number] =, DiscountID = {'Reduction'} >} Total AmoutOfDiscount)
thanks
Joe