Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
670
Summaries without Columns?
posted

Hi folks,
I'm wondering if I can do a formula summary without adding additional columns. I have a grid with a lot of columns and rows. Rows represent accounts (in a different currencies) and columns represent different types of values.

Now, what I want is to be able to summarize each column and apply the appropriate foreign exchange rate to get a summary of everything in a specific currency.

Account Ccy fx rate v1 v2 v….
1 eur 0.74 3.4 5.6 8.8
2 gbp 0.58 5.5 7.6 9.9
3 zar 10.11 6.7 8.8 3.3
   
Total USD   73.443 97.52 45.617

The way I have done it is to add an extra column for each value column and put a formula in there. Trouble is I might have very, very many columns so I'm worried about performance, etc.

I suspect there is a better way?