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.
test.qvw 141.2 K
Thanks for the reply.
This won't work unfortunately because InvoiceValue1 and InvoiceValue2 are actually from the same column e.g. InvoiceValue only.
Basically I am looking for something like this:
IF(count(InvoiceNumber > 1, Compare InvoiceValue against other(s) InvoiceValue where the InvoiceValue is 0.01p different, show the Invoice Number, else ignore.
I hope that makes sense