Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression from table 2 okay :-
Sum({<rEVENUE={rEVENUE}>}Amount)/Rate
Below expression from Table 3 not okay :-
(
sum({$<YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate
-
sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate
)
/sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate
May i ask why first expression allow to place /Rate after Amount) , and second expression not allow ?
Paul
my QVW
What is the rate that you expect to see?
Hi Sunny
Now table 3 display -7% is wrong , it should display -47% as shown in Table 4.
I cannot understand why if i put Rate out side Amount)/Rate at Sum expression it is okay , but not okay when compute GP% ?
Paul