if formula

[anitamanders]

Hi,

I have a standard table for quotations (based on article codes) with columns quotation price and minimum price.

I have made a formula in dimension of quotation price that turns background colour of quotation price red if

quotation price < minimum price

=if ((offerteregel_prijs < [minimale verkoopprijs]) , red(150)) 

But there are article codes that do have a quotationprice, but don't have a minimumprice (there is no value) In that case the background of the quotation price should also turn red.

I have tried it with this formula:

=if ((offerteregel_prijs < [minimale verkoopprijs]) or   [minimale verkoopprijs] = '0', red(150)) 

In the presentation of the table I marked 'null-symbol" as: 0

But this does not seem to work.

Any one of you, who can help me out with this?

[isingh30]

May be this -

if ('offerteregel_prijs'< 'minimale verkoopprijs' or   'minimale verkoopprijs' = 0, red(150))

Thank you!

[isingh30]

You are doing this in the background color under dimensions?

[olivierrobin]

hello

try to add

or isnull(minimumprice)

to your condition

[sunny_talwar · Accepted solution]

Try this

=If(offerteregel_prijs < [minimale verkoopprijs] or Len(Trim([minimale verkoopprijs])) = 0, Red(150))

[anitamanders]

yes

[anitamanders]

Thank you, this works fine !