hello I need to divide the values of two filds.They are the same fields but have a different record id's is there a way to do it.

Hello,
It's based on two conditions
1)if the type of sample is outside 
2)The type of mold should match for both the records

In general it is very difficult to do more mathematical operations involving different records. But in any event your explanation is far from sufficient to give you an answer. What if there is 1000 records on your table. How was it supposed to know which two records you want to divide.

hello,
I have a table which consists of different mold samples.I have to calculate the failure percentage.To calculate the failure percentage I need divide two fields which are of the same mold but collected in different locations.I hope this is sufficient for my explanation._

Can you tell me if there are any relationships in your application. For example does one mold have many child records that represent production or failures.

Also I am no expert in your manufacturing process but one would think that moulds would get reused over and over and over. They must be used on multiple days. So I imagine the moulds them selves would have hundreds of production records and hundreds of failure records

Yes this is a child table.The parent table is called as lab reports.

How many child record does a Lab report have?  How do we know which record is divided by which record.  

The lab reports has approximately 10 child records.And the division is based on 2 conditions as mentioned previously.

1)the second record's location has to be outside
2)the mold of record one and record 2 have to be the same.

Hi Kristy,

I put together a quick app to demonstrate a method to solve your problem in a different manner that does not rely on performing a calculation between values stored in two different records. Instead, we can summarize the number of Tests that use a given mold and further summarize the results of those tests based upon conditions and results.

To achieve this, it is necessary to create a third table called tests and relate it to the Lab Reports table  and Molds table so that you  create many tests using the same mold.  Additionally, I created fields in the Tests table to store Test Condition and Test Result to be used for filtering and summarizing results in the Lab Reports table.

The app workflow is something like

Create or import Mold records
Create a Lab Report to associate the molds with the Report
Create test records to record the results for each of your test iterations.

https://builderprogram-jrichey.quickbase.com/db/bpp5d6qnt

Thank you so much jeff. But I cannot summarize the values here.I need to actually divide the vales.This is different from what i actually have.

I'm sorry that this does not work for your situation. You will most likely have to share your application with someone so that they can more fully understand your environment and your objectives to help you solve your problem.