Bug in Calculation

[Kiwi]

I have an Invoice Items table that requires a Line Item field. It is a summary field that is used when the table is sorted by invoice number. Very simple - it numbers the item records from 1 to x where x is the last item within each invoice.

The table also contains a calculation field that is equal to the summary field.

The summary field and the calculation field work great in the data file.

In the interface file - the summary field is correct - but the calculation is not!!!

Here is a test db I made to duplicate this special feature.

The tables need to be sorted by Invoice Number.

I have found a workaround and have included that in the sample files attached. I would still like to know why is does not work!

Cheers.

data.zip