My Ration for Rev vs Net Profit expression return -96% how to make it display 4% ?

[admin11]

Hi All

I want to compute Ration for Net Profit vs Revenue.

I have 2 field name :-

YTD_REV

YTD_NET PRO 

I create an expression below :-

R_EXP_REV = (if(isblank( divide(

[_YTD_NET PRO]

-

[_YTD_REV_]

,

[_YTD_REV_]

)),1, divide(

[_YTD_NET PRO]

-

[_YTD_REV_]

,

[_YTD_REV_]

)))

Above expression return -96% , which is wrong. i use excel to compute the answer = 4%

195000

5210000

0.037428

Can some one advise me how to modify the expression , so that i can get 4% ?

Since 100-96 = 4

May i know how to insert 100 infront of the expression.

Paul

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

R_EXP_REV = coalesce(divide([_YTD_NET PRO],[_YTD_REV_]),1)

[admin11]

@Ashish_Mathur 

Thank you very much , it work fine now. Look like you know most of my problem.

Paul

[Ashish_Mathur]

You are welcome.