AnsweredAssumed Answered

Dynamic Maths?

Question asked by Stu412 on Apr 22, 2015
Latest reply on Apr 22, 2015 by Jade

Title

Dynamic Maths?

Post

Hi there

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

Outcomes