topic Re: Why i cannot divide by Rate in my GP% Expression ? in App Development

Why i cannot divide by Rate in my GP% Expression ?

paulyeo11 — Tue, 21 Jun 2016 13:12:14 GMT

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

paulyeo11 — Tue, 21 Jun 2016 13:13:26 GMT

Hi All

My QVF Doc

jonathandienst — Tue, 21 Jun 2016 13:33:17 GMT

And if you put the RATE inside the Sum?

sum({$<YTD = {'-1'} , rEVENUE={rEVENUE}>} Amount/Rate)

paulyeo11 — Tue, 21 Jun 2016 21:53:48 GMT

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