Hi,
I need to query a table, that has two numeric fields, but only one of them has value, the other is empty(The table has value either in the amount or in the quantity field).
I need to get the sum of the ones that is no empty, so the problem is that I don't know which field do I need to target. Is there a way to make a query for this?
Thank you