Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this
=If(offerteregel_prijs < [minimale verkoopprijs] or Len(Trim([minimale verkoopprijs])) = 0, Red(150))
May be this -
if ('offerteregel_prijs'< 'minimale verkoopprijs' or 'minimale verkoopprijs' = 0, red(150))
Thank you!
You are doing this in the background color under dimensions?
hello
try to add
or isnull(minimumprice)
to your condition
Try this
=If(offerteregel_prijs < [minimale verkoopprijs] or Len(Trim([minimale verkoopprijs])) = 0, Red(150))
yes
Thank you, this works fine !