Totalling Percentage

[Tom England]

I have 8 fields "Percent1" --> "Percent8"

I want to know if it is possible to do the following.

Users may put 10% in "Percent1". I then want "Percent2" to show 90% (100% - 10%) But(!) I then want to allow users to be able to input in "Percent2". If they input 30% in field 2 I want "percent 3" to show 60% (100%-10%-30%)

Is there any way to do this? I can validate it so that the total of the fields cannot exceed 100%, but from an aesthetic point of view would like the next field to auto-enter.

Does that make sense??!!

[andygaunt]

Tom,

Email me your private email. Can send you a file.

For list purposes here is an example.

you can have a calculation field for each value that looks to see if the editable field (percentx.disp)field has anything in it and that the total is not 100%. If this is true, display the remainding amount for the percentage

If(

IsEmpty(percent2.disp) and Total Percentage <> 1, 1 - percent1.disp,"")

this for the first field (percent 2)

then for each subsequent field build up the calculation

If(

IsEmpty(percent3.disp) and not IsEmpty(percent2.disp) and Total Percentage <> 1, 1 - (percent1.disp + percent2.disp),"")

[andygaunt]

Here is the url of the sample.

http://www.albion.co.uk/fmpro/percent.zip

(3Kb)

[Fitch]

Sounds like you don't want auto-enter to happen unless there is a "balance." Set up auto-enters like this:

Percent2:

Case(100 - Percent1 = 0, "", 100 - Percent1)

Percent3:

Case(100 - Percent1 - Percent2 = 0, "", 100 - Percent1 - Percent2)

Percent4:

Case(100 - Percent1 - Percent2 - Percent3 = 0, "", 100 - Percent1 - Percent2 - Percent3)

etc.

Not exactly elegant -- but no calculation fields required.