How to enable conditional value for a record to hide in a Column field

[Anonymous]

Hi,

I have one small doubt. How can I set a condition for a field in Column.

I have below data in a Straight table and I want to hide or set to null the records "Sales" in column "Department Type".

I tried functions Match, GetSelecFields and Set Analysis but unable to solve this issue.

Can anyone help me?

"Date" "Category" "Department Type" "Employee"

1      IT                   Software                A

2    NonIT               Sales                     B

3    NonIT               Sales                     C

4     IT                    Software                 D

5     IT                    Software                 E

I do not want to see Sales in Department Type column and result should be either 0 or Null.

Thanks,

Shiva.

[Anonymous]

Andy,

For suppose, if we want to hide other field for example 'HR' also in 'Department Type' what would be the expression.

Req: "Sales" and "HR" should miss in records of column "Department Type".

"Date" "Category" "Department Type" "Employee"

1      IT                   Software                A

2    NonIT               Sales                     B

3    NonIT               Sales                     C

4     IT                    Software                 D

5     IT                    Software                 E

6   IT-Related         HR                         F

[awhitfield]

Hi Shiva,

like this

=If([Department Type]='Sales' OR [Department Type]='HR',
NULL(),[Department Type])

Andy