# Checkbox calculation problem.

• December 3rd, 2012, 07:39 PM
Crispan varro
Checkbox calculation problem.
I have this problem i can't seem to figure out,i'll do my best to explain it here.

I have a series of checkboxes each one having a name and a value and a person can choose either one or all of the boxes(it can't be radiobuttons because you can only make a single choice)
I want to know if it is possible to calculate the total amount if the person chooses any number of checkboxes from one to eight.
I.e checkbox1 value = 5
checkbox2 value = 15
checkbox3 value = 7.
etc

I would apprieciate any kind of help here thanks
• December 4th, 2012, 01:07 AM
dglienna
Re: Checkbox calculation problem.
Probably, but a more exact definition is needed. Plus, show some code of how you THINK it should work...
• December 4th, 2012, 08:04 AM
DataMiser
Re: Checkbox calculation problem.
If you mean could you tell which and/or how many are selected then of course you can.

No idea what you are trying to do though you little example of checkbox values is just confusing as those would not be valid values for a checkbox.
• December 4th, 2012, 09:31 AM
Crispan varro
Re: Checkbox calculation problem.
Quote:

Originally Posted by DataMiser
If you mean could you tell which and/or how many are selected then of course you can.

No idea what you are trying to do though you little example of checkbox values is just confusing as those would not be valid values for a checkbox.

Its part of a project i am trying to build.After a client chooses what car they want and how many days they want to rent it for ,you would then calculate the total amount owed for the rental.i have that part worked out,the second part is the one that i can't figure.

after the vehicle selection has been made the client chooses from five differant extras,these are,

Childseat @ �10 fixed rate
sat-nav@ �5 fixed rate
Luggage rack @ �15 fixed rate
Ski-Equiped @ �10 fixed rate

Choice on the form is made via a checkbox for each item,the client can choose either one or all of the extras,my problem is how to workout how to calculate the total owing for the extras based on how many checkboxes have been choosen

Code:

``` Public class Rentalform 'declare module level constants Const CHILDSEAT_EXTRA as Decimal = 10 Const SATNAV_EXTRA as decimal = 5 const LUGGAGE_RACK_EXTRA as decimal = 15 Const SKI_EQUIPED_EXTRA as decimal = 10 if chkChildseat.checked = true and chkSatnav.checked = false and chkLuggageRack.checked = false and chkSkiEquiped.checked = false then txtTotal.text = CHILDSEAT_EXTRA If chkchildseat.checked = true and chkSatNav.checked = false and chkLuggageRack.checked = True and chkSkiEquiped.checked = false then txtTotal.text = (CHILDSEAT_EXTRA + LUGGAGE_RACK_EXTRA )```
Do i have to churn out streams of code to cover every possible choice variation i.e chilseat only,childseat and Luggagerack or maybe the client chooses all of the extras. Help please
• December 4th, 2012, 09:39 AM
Crispan varro
Re: Checkbox calculation problem.
Its part of a project i am trying to build.After a client chooses what car they want and how many days they want to rent it for ,you would then calculate the total amount owed for the rental.i have that part worked out,the second part is the one that i can't figure.

after the vehicle selection has been made the client chooses from five differant extras,these are,

Childseat @ 10 fixed rate
sat-nav@ 5 fixed rate
Luggage rack @ 15 fixed rate
Ski-Equiped @ 10 fixed rate

Amounts above are currency (pounds,Euros,Dollars)

Choice on the form is made via a checkbox for each item,the client can choose either one or all of the extras,my problem is how to workout how to calculate the total owing for the extras based on how many checkboxes have been choosen

Code:

```Public class Rentalform 'declare module level constants Const CHILDSEAT_EXTRA as Decimal = 10 Const SATNAV_EXTRA as decimal = 5 const LUGGAGE_RACK_EXTRA as decimal = 15 Const SKI_EQUIPED_EXTRA as decimal = 10 if chkChildseat.checked = true and chkSatnav.checked = false and chkLuggageRack.checked = false and chkSkiEquiped.checked = false then txtTotal.text = CHILDSEAT_EXTRA If chkchildseat.checked = true and chkSatNav.checked = false and chkLuggageRack.checked = True and chkSkiEquiped.checked = false then txtTotal.text = (CHILDSEAT_EXTRA + LUGGAGE_RACK_EXTRA )```
Do i have to churn out streams of code to cover every possible choice variation i.e chilseat only,childseat and Luggagerack or maybe the client chooses all of the extras. Help please
• December 4th, 2012, 02:04 PM
Rburn99
Re: Checkbox calculation problem.
You could do something like this.

ExtrasCost = 0
If chkChildSeat.Checked = True Then ExtrasCost = ExtrasCost + 10
If chkSatVan.Checked = True Then ExtrasCost = ExtrasCost + 5
if chkLuggageRack.Checked = True Then ExtrasCost = ExtrasCost + 15
if SkiEquipped.Checked = True Then ExtrasCost = ExtrasCost + 10
• December 4th, 2012, 02:24 PM
dglienna
Re: Checkbox calculation problem.
Just keep a RUNNING TOTAL between the calculations. Create a CALCULATE function that calls each IF/THEN as a separate FUNCTION that returns either a value or ZERO.