A need has arisen to show/hide and include/exclude details and values in a form based layout.
I have a data table in the format:
Description | Total
Desc1 | 1000
Desc2 | 2000
Desc3 | 3000
In turn, this would be shown on my layout currently in a portal. The total at the moment is 6000.
What I need to be able to do on the same form is:
1) Have the user select which rows to include or exclude
2) Have FM hide the appropriate rows
3) Have FM add up the values for the remaining rows.
For example, if a user selected to hide row 2, the new total would be 4000.
Any ideas at all on this??
Thanks in advance