I have a small issue that's really beginning to bug me.
I have a database with say the following columns:
- InvoiceValue - InvoiceDate
What I am trying to do is create a straight table that looks for duplicate invoices where the invoice number is the same (easy) but also the invoice value is within 0.01p (tolerance). I can't seem to get the expression correct for the 0.01p part.
I think this is most probably really simple, but I just can't get it right.
Hi, the best thing would be to add in a flag to the load script, but assuming you need to have this dynamically based on other selections have you tried loading a copy table joining on the invoice number then comparing the values in the two tables? i've attached an example.