Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a simple table chart containing dimensions and several calculated expressions. I need to total up the expressions (about 18 in total) into another column in the table. numsum does not do the trick. Any other ideas?
Thanks!
Maybe I'm missing something, but column(1) + column(2) + column(3) + ... + column(18)?
That doesn't work, I've tried it. the columns are calculated expressions.
It doesn't matter. Use expression names in place of John's column(n). Or write a new expression like this:
<expression of column 1> + <expression of column 2> +...
I don't know why it wouldn't work. It works just fine for me where the columns are calculated expressions. See the attached. Is it possible to post an example of the problem you're seeing? Alternatively, does my example show you that I'm misunderstanding your question, and if so, can you clarify?
It might not work if some of the columns return nulls - then the whole expression is rendered as null. The way around it is using rangesum:
=rangesum(Column(1), Column(2), ..., Column(18))
Ah! Of course. Good point. That could easily be the problem.