Hiding Columns

[Anonymous]

Hi

In a straight table I want to add 2 columns together in another column and hide the 2 original columns.  In the calculated column I have put the expression column(2)+column(3).  This adds the 2 columns together correctly, however when I try and hide columns 2 & 3 by ticking the conditional check box and putting 0 or disabling the expressions I just get an error.

Please help

Thanks

[jsanchezh]

Hello,

The problem is that if you hide or disable them, then they are no longer column(2) and column(3). You can try one of this solutions and see if it works:

     a) Name the expressions as Column2 and Column3 (or other names) and then in the expression for the new column write "=Column2 + Column3"

     b) Write the complete expresion in the new column =expresion_column_2 + expression_column_3

I hope it's been helpful

Greetings!

[Anonymous]

I think sharing the sample application is required or at least share the error message you are getting

have u added at least  1 expression

[Gabriel]

Hi,

The expression in each of column 2 & column 3, is it possible to create the expression in the script. Which then gives you the flexibility to have a column 4 (combination of column(2)+column(3).)?

[Anonymous]

I tried option (a) but with the same result.  I'm trying to avoid option (b) as this would mean I will need 'if' and 'aggr' expressions

[Anonymous · Accepted solution]

try to Keep column(1) and column(2) enabled, BUT hide both columns under presentation

then the column(3) should show correct results

[Anonymous]

Brilliant Thanks