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

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.

0 4 335
4 REPLIES 4

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?

@Bjarne_Allerup

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

Tnank you Levent Translate

Youโ€™re welcome @Bjarne_Allerup

Top Labels in this Space