How to compute Net Profit % in PnL ?

[admin11]

Hi All

I have below expression working fine :-

AMOUNT_GP = DIVIDE([AMOUNT_REV_N]-[AMOUNT_COGS_N]*-1,[AMOUNT_REV_N])

Now i like to modify the above expression to get Amount Net Profit , below is my expression :-

AMOUNT_NP = DIVIDE([AMOUNT_REV_N]-[AMOUNT_COGS_N]-[AMOUNT_EXP],[AMOUNT_REV_N])

it return wrong result. May i know where go wrong ?

Paul Yeo

[VijayP · Accepted solution]

@admin11 

Net Profit is the result of Revenue - Expenses so your formula should be 

Divide (revenue minus Expenses, Revenue,0) then you will get right result!