Calculate Profits among a few conditions

[Aliq21 (Christian Higgins)]

Hi there, my objective and goal with this is to calculate my NET PROFIT. After a condition.

Here is my deal status board for my real estate company, I want to calculate.
Sale price- Purchase price - expenses. But ONLY if the SALE price column is filled out. If it (Sales Price) is not filled, I want it to return with 0 or blank.

When I have the formula set for this without the condition. On deals we haven’t yet sold, it shows -60,000 or -100,000 for net profit etc. And it messes up my KPI’s, thanks!

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi @Aliq21,

Did you try?

IF({Sale Price}<>0,{Sale price}-{Purchase price}-{expenses},0)

[Aliq21 (Christian Higgins)]

Hi Cavin, yes I just tried it. Same issue is showing.

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Add a screenshot of your formula, because it shouldn’t give you the same result.

[Aliq21 (Christian Higgins)]

Here’s two screenshots of t

he formula already set and utilized

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Indeed it is a bug. Try:

IF({Sale Price}>0,{Sale price}-{Purchase price}-{expenses},0)

[Aliq21 (Christian Higgins)]

Wow, thanks so much Cavin. That worked!!!