Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Why Amount)/Rate not allow when compute GP% ?

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

3 Replies
paulyeo11
Master
Master
Author

my QVW

sunny_talwar

What is the rate that you expect to see?

paulyeo11
Master
Master
Author

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