That shouldn't make a difference as a whole number such as "1" would just be "1.00" in currency format.

The issue appears to be the use of &currentiteration and it not being in scope. This will happen when you don't have a repeat set in the object. Can you confirm that you are doing a line repeat in this Text Object?

Regards,

James.

Thank you James.
Yes, I am doing line repeat to fill in the table detail for 'extended price' I had to manually cycle the iterations because I use a custom data selection. I have to use the custom data selection to format the 'unit price' strtocur and to do the calculation of unit price * qty. Because the iterations do not cycle when using a custom data selection I had to manually increment. This all works perfectly in the table detail.

Now, in the footer detail for 'subtotal' I need the sum totals of all the extended cost line items(which were calculated in the table detail). This could be a separate calculation.

In order to get the extended price I wrote this:

=curtostr(strtocur(strip('*', XmlGet('/Document[1]/Page[1]/CommercialInvoice[1]/CILines[1]/CILine['+inttostr(&currentiteration)+']/ShippedQty[1]'))) * strtocur(trim(XmlGet('/Document[1]/Page[1]/CommercialInvoice[1]/CILines[1]/CILine['+inttostr(&currentiteration)+']/UnitPrice[1]'))))

This formula works for each iteration and cycles correctly for the invoice table inside of the textbox which I'm using line repeat in.

The footer where the 'subtotal' value needs to be is not in that text box where I'm doing line repeat. It is it's own text box.

Then you have to define your own iterator variable, inside your loop, and it should work.

OK, I see where I went wrong.

I needed to add the code to the table detail text box which is doing the line repeat and add the presstalk after to set it into the global variable. Then use the global variable in the footer.

TY!

The only thing left is to add the commas to the amounts because the values are sometimes millions.

I do not see a reference to that type of formatting in my manual. Is this something simple or does it require a plugin? or?

You need to code it yourself. It shouldn't be to complicated.
I would setup a function which receives the current amount (in string format) and returns the formatted string, with commas.

Simply loop through all characters backward, starting at the first one before the decimal "dot".

Every third character, you add a comma.

OK, got it. ty