Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a straight table (Object ID CH233) and I'd like to add columns 1 & 3 together and display in a text object. Something like the expression below
= (CH233,Column1)+ (CH233,Column3)
Object CH233 only has 1 row of data so doesnt need to be totalled first.
Does anyone know if this is possible and what the correct expression would be?
HI Gavin
I would use the expressions of each column, and sum them in the text object instead of using the Columns.
Columns work great inside a chart for let's say a 4th expression, but I would use that solution instead
Hope it helps
Regards
Pablo
No, that's not possible. You can't reference values in cells in other objects. You will have to reuse the expressions that calculated the values you wish to add. You will probably have to use the aggr function to get the right values.
sum(aggr( ...1st_expression_from_ch233... + ...2nd_expression_from_ch233... ), Dim1, Dim2,...,DimN)).
Replace Dim1, Dim2,...,DimN with the dimension names of the dimensions of CH233
OK..Thanks guys. Kinda guessed I would.