I am having trouble creating a report because I have nulls pop up in the tables I'm using.
If I have a query that takes sum(quantite * price * discount)
and the discount is null I get null as the sum.
Is there any way to take the greater of 2 values ie
select greaterOf(discount, 1)?