Calculation assistance

Hello,

I have Joomla 2.5.8 and Payment Form 3.0

I have a form at

carriedup.com/index.php/mount-kenya/book...?view=form&form_id=1

The total I need to calculate would look like this in maths

((route)x(citizens))+((route)x(residents))+((route)x(non-residents))+((Carried))

What numbers do I put where, and where do I put the calaculation?

Is it OK to use double brackets?

Thanks

Hi Martin

I need to look at the back-end of your site to see how you setup the fields. Basically, if you setup correctly, you can :

1. Set Fee Field attribute of the Which Route field to Yes .

2. Enter [FIELD_VALUE]*([PF_CITIZENS] + [PF_RESIDENTS] + PF_NONRESIDENTS) + [PF_CARRIED] into fee formula of the Which router fied.

3. For all other fields, please see Fee Field property to No.

After that, it should work as expected .

Tuan

Many thanks for the suggestion but the trouble is each route has a different price for each customer type.

EG

route citizen resident nonresident

S-S 300 400 500

The point being that the calculation must take into account the number of each customer as well as the customer type

Please advise

Ah, wait a minute, each of the customer types has an individual fee field...

That would take care of my problem right?

Martin Muckle wrote: Ah, wait a minute, each of the customer types has an individual fee field...

That would take care of my problem right?

Sorry, I don't see customer types on the form. Did you try the solution you mentioned ?

Tuan

The customer types are

Non-residents
Residents
Citizens

These are the types of Kenyan residency status and are charged differently accordingly

Hi,

Sorry, I have tried your suggestion but it returns $0 as payment amount

Please advise

Thanks