I made a table with fixed assets showing the following columns:
1. Asset number
4. Accum. Depreciation
5.Net Book Value.
Column 3 is an expression with formula (x)
Column 4 is an expression with formula (y)
Column 5 ( net book Value) is the result of column 3 -/- Column 4 i.e. Formula(x) -/- formula (y)
The user asked me to switch between Only showing columns with Net Book Value > 0 or Showing all columns ( Inlcusing NBV = 0 )
I van make a variable and let the user choose the option, but how can i implement the selection i.e. showing only columns with NVB > 0 or showing all columns ? I can see/find no option to conditionally skip a line in the table depending on a condition.
If your script worked well, you should have Y for the lines where NBC = 0 and N where NBC <>0.
First check if it's the case.
With this field, you can simply select only lines <> 0, =0 or both. Creat a list box with this field and you can use it.
An other solution could be to create a Button and set an action to select N in your field 6 when user clic and clear this selection when reclic. If this solution meet your needs i can explain more on How To Do.