Hi All I want to compute Ration for Net Profit vs Revenue.I have 2 field name :-YTD_REVYTD_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% 19500052100000.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

Hi, Does this measure work? R_EXP_REV = coalesce(divide([_YTD_NET PRO],[_YTD_REV_]),1)

Memorable Member

5 years ago

Solved

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

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_]

)),1, divide(

[_YTD_NET PRO]

[_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