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.
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?
Can anybody tell me if this'd be a more efficient way? I'd imagine it would be because, of course ,we'd have less column objects but I wonder if the performance of looping through rows, etc. would compare with what happens under the hood?
Thanks for the reply by the way.
I would say it is more efficient simply because there are much less formulas. You previously had a formula set for each unbound column and each summary. Now, you would only have a formula set for each summary.