Hi

BIP has the concept of variables (check the docs) so you could create a variable x to hold an initial value of say 10000. In the loop, check the value of the calculation against the variable value and update it accordingly. At the end of the loop you would have the lowest value.

TBH thou, I think I would push all of this into the data model. Have a field in the query that calcs the difference. Then create a summary column at the report level that looks for the min value. It will perform much better in the data model and the layout template will be cleaner

Tim

Ahhh ... thats a slightly different question. You don't want the minimum value, you want the invoice number that has the lowest amount correct?

For that I'd use a second query to get that id, something like

select invoice_num

from invoices

where rev = (select min(rev) from invoices)

You could do it in the template but again, its going to be expensive in terms of time and processing and its better to push it to the data model.

What happens in the maybe rare case that you have two or more invoices with the same lowest value? The query above will return two rows and you can loop through them in the template to show them.

Tim