I would like to view only certain data (in this example, where field1+field2 >= 40). This is a straight table.
I have 3 fields in the data, serial#, field1 and field2.
Calculated field has expression Calculated field = field1+field2.
Visible has expression where if(field1+field2>=40, 'Y', 'N')
Serial#
Field1
Field2
Calculated Field
Visible
1
11
21
32
N
2
12
22
34
N
3
13
23
36
N
4
14
24
38
N
5
15
25
40
Y
6
16
26
42
Y
7
17
27
44
Y
8
18
28
46
Y
Qn1:
How can i see the table in the following format? Do i need to create another tabe? do i have to do the calculated in expression tab, or general tab->expression?
Serial#
Field1
Field2
Calculated Field
5
15
25
40
6
16
26
42
7
17
27
44
8
18
28
46
Qn2:
How can i expression "visible" in 1st original table without reusing the formula, ie. if(field1+field2>=40, 'Y', 'N') or can i use if(column(4)>=40,'Y', 'N'))?
