Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

How to compute Net Profit % in PnL ?

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
 
Need Help
  • VijayP's avatar
    VijayP
    4 years ago

    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!

1 Reply

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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!