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
