Currency & exchange rates — Totalling a column that holds several currencies

Summing a column of dollars and pounds by adding the numbers gives you a total of nothing. So wherever RowFold adds money up — a column total on the grid, a group subtotal in a report, a KPI or chart tile on a dashboard — it converts each record at the rate in force when that record was created and adds the converted amounts. That is how transaction-date conversion works in accounting, and it means the answer does not drift as rates move. Only the total converts. The records themselves keep the currency they were written in: a £250 deal still reads £250 in its row, next to a total that has counted it as $317. Restating the row would be the product asserting an amount nobody agreed. If a pair has no rate, nothing is guessed. The grid says Mixed currencies instead of a number; a report shows the total it could reach and states the shortfall beneath it — “38 of 41 — 3 need a GBP → USD rate”. No unconvertible row is quietly counted as zero or treated as parity, because a total that silently covers part of a column looks complete and isn't.