Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression it alway display 0 % when i select SOURCE = TDSID :-
(
sum({$<YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate
-
sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate
)
/
sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate
After i remove the /Rate as below , And it work fine :-
(
sum({$<YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)
-
sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)
)
/
sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)
My question is why i need to remove /Rate to make it work ? as logically it is a constants , so it should not affect the result. but it does .
Paul
And if you put the RATE inside the Sum?
sum({$<YTD = {'-1'} , rEVENUE={rEVENUE}>} Amount/Rate)
Hi All
My QVF Doc
And if you put the RATE inside the Sum?
sum({$<YTD = {'-1'} , rEVENUE={rEVENUE}>} Amount/Rate)
Hi Sir
If what you said is correct , the error due to rate must place inside the sum.
Why I only get 0% when source = TDSID ?
Paul
Sent from my iPhone