I have a form with $ and currency amounts (along with a bunch of other fields) that i would like to sum the amounts for each currency (USD CAD)
typically i would add a text field at the form footer as follows: =sum([amt])
this works perfectly if there is only 1 currency. Typically there are both USD and CAD though. Can someone suggest how to sum the [amt] fields for each [currency] ?
thanks in advance