Hi,
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'))?
thanks!
