Sum (Calculate)

[Roberto29o]

Need help.

Whow can I sum fields?

What I mean for example  is I have 2 fields One Pallet 1 and the other is Pallet 2 and if I sum, the total is going to be 3 but what I want is in the total pallets field the amount is 2. this is to add or sum the total number of pallets shipped.

Thank You

[Niall_O_Donovan]

Hi,

Not sure if I get what you are looking for, but...

If the two pallet fields are named: pallet1 and pallet2. Then the following script in the calculate event of totalPallet should work (note script is FormCalc):

$ = Sum(pallet1, pallet2)

Hope that helps,

Niall

[Roberto29o]

Thank You Niall. You are Grate

I found a way to do it. It may be wrong but it was easy.

It was Count (Field1, Field2, Field3 etc...)