Calculated/Total Field

[Angela_(Guest)]

We are a production comany and trying to do repricing of our assemblies. ____So we have one record band and one band referencing a specific field. ____The record field is where all the parts of the assmebly are showing up with their individual cost, ext cost price.____I need to create a field that will take the sum of the assm parts cost, preferably the extended cost, subtract the freight and labor figures that are apart of the assembly. This field would be cost w/o frieght and labor. ____Our intent is to multiply that # times a set rate to figure out our new frieght cost. ____Someone had suggested to also try and write the field that is should sum all numbers but the figures listed. I am not quite sure how to do this. I am not all that familar with writing this kind of a formula.____If someone would help me, I would greatly appreciate it.____Thank you for taking the time to read this.____Angela

[Rick_Johnson_(Guest)]

Lets say you have parts costs, P1, P2, P3, Freight /Labor (FL) , and an extended cost (Ext). So on a record line you have at least P1 P2 P3 FL Ext____Create a caluclated field, totB4, and make the value P1 + P2 + P3____Then create another calculated field, NEWFL, and make its definition to be TotB4 * (whatever percentage you want). This wll give the new FL. ____Place NEWFL on the report line to display it. You may need to round NEWFL to get it to dollars and cents.____As you get better at calculations, you can do this all in one calculated field- NEWFL = round(((P1 + P2 + P3)* percentage),2) ____You will find the form to do these fields under Calculations-Calculated Field, then click NEW, and go for it.