Hi,

The DimAccounts table is only there to provide with the column AccountCodeAlternateKey for the WHERE filter.

It is the Amount column of [dbo].[FactFinance] I would like to update. That column is also the source column for the running totals. If this will be a problem I don't mind creating a new column for the update. I can do this alteration of the [dbo].[FactFinance] table in advance.

Best regards