HI, How do I write this?: Profit = Sales P...

(Bjarne Allerup) #1

HI,

How do I write this?:

Profit = Sales Price - Purchase Price Run at every edit but only if Sales Price not 0

Thanks in advance.

(Bjarne Allerup) #2

Found a solution:

In show if:

=[Sales Price]<>0

in App formula:

=[Sales Price]-[Purchase Price]

But could I put it all in the App formula?

(Levent KULAÇOĞLU) #3

@Bjarne_Allerup

=IFS( NOT([Sales Price])=0, [Sales Price] - [Purchase Price] )

(Bjarne Allerup) #4

Tnank you Levent Translate

(Levent KULAÇOĞLU) #5

You’re welcome @Bjarne_Allerup