Trying to write a query in Discoverer and can't find any sort of If function. I just want to do what in Excel would be:
If([Cost] < 500, 0, [Cost] - 500)
I.e. if the Cost field is less than 500 replace the value with 0, otherwise deduct 500 from the value.