Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
The attached qvw will explain the issue better than I can in words. Note my production qvw is a lot more complex, however this explains the crux of the issue
Basically I am tying to create an index value based on a number of columns, I can do this absolutely fine in a chart for the selected dimension.
The formula is:
((((SUM(ACTIVITY) / SUM(COST))/(SUM(TOTAL ACTIVITY) / SUM(TOTAL COST)))* SUM(ACTIVITY))/(SUM(TOTAL ACTIVITY) ))*100
What I then want to do, is show the same value in a chart for ALL dimensions, even though one of those dimensions is selected
However the index value is the sum of a calculation done at a line level so for company A index = 1503.90
This is what I want to end up with, but with the right values:
My current formula is:
sum( {<COMPANY-= >}
aggr(
SUM({<COMPANY-= >}
AGGR(
(
(
( /*weight*/
(sum({<COMPANY-= >}COST)
/ sum({<COMPANY-= >}ACTIVITY)
)
/
(sum(TOTAL {<COMPANY-= >}COST)
/ sum(TOTAL {<COMPANY-= >}ACTIVITY)
)
)
*
( /*activity*/
sum({<COMPANY-=>}ACTIVITY)
)
)
/
/*total activity*/
sum(TOTAL {<COMPANY-= >}ACTIVITY)
) *100
,CODE,COMPANY)
),COMPANY
)
)
Now I am 99% sure this is going wrong due to the TOTALs, because it is using the totals for ALL dimensions, not PER dimension
But I am going in circles trying to figure it out!
Accepted Solutions
I think this might be the reformulated expression that could calculate what you want - I attached the modified QVW too:
I think this might be the reformulated expression that could calculate what you want - I attached the modified QVW too:
