Currency & exchange rates — Good to know

• Where a Rollup, Lookup or Formula really does convert money — its source column holds more than one currency, or one that is not what it reports in — the grid stops totalling, sorting, filtering and grouping by it, because those are computed by the database over every matching row and it cannot apply a per-record rate chosen by a per-record date. The summary cell says so and names why. A report's aggregate column across the same link converts and totals correctly; take the question there. A column whose money is all in one currency keeps every one of those controls, whether or not the workspace records several.