Total fields in each record

[danielw]

I have a database with fields of weight.steer, weight drive and weight.tandem I would like to be able to total these three fields in each record and display in a new field called total weight.

Thanks,
Dan

 

[HowardHammerman]

Create a new formula field with the following expression:

{weight.steer} + {weight drive} + {weight.tandem}


I am assuming that all three are numeric fields. If they are character fields you will have to use the value function:

value({weight.steer}) + value({weight drive}) + value({weight.tandem})




Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[danielw]

Thanks Howard. That was easy. I was trying to make the same formula but it had to = a field.

Thanks again.

Daniel

 

[HowardHammerman]

you are welcome. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269