Hello!
My airtable base gets new data imported into it every week from a separate report that is run. One of the drawbacks of the report is that it calculates revenue for our contracted associates, but not for our direct hires. In order to find the revenue for our direct hires, we have to divide the direct hire fee (DP Fee) by 13.

Since we have the data for the contracted associates, is there a way to manipulate this field to leave certain data alone, but also divide other data by a factor?

Screenshot below of data set to give you a better idea! Note that the field in question is âPIT Spreadâ. We are currently calculating these values for direct hires prior to adding new data to our database.

If I am understanding you would like to divide numbers in the DP Fee field by 13. The way I would go about this would be to make a Formula field using the formula â{DP Fee} /13â. This should give you the selected outcome.
If you would only like to do this with certain numbers in the DP Fee field then I would suggest adding tags for direct hires and then rolling up only the values with tags associated.

Sorry, so yes, I would like that equation to be added to the PIT Spread field, but only for DPs. The PIT Spread field also contains data already for our contracted associates, so I would like to know how to leave the existing data in the PIT Spread field alone while at the same time calculating PIT Spread for DP.

Welcome to the community, @Kristina_Cadle! One way to do this would be to make a formula field as @Reid_Thomas suggested that calculates the end value, dividing {DP Fee} by 13. Create a new automation that triggers when {DP Fee} is not empty (i.e. itâs a direct hire). The only action needed is an âUpdate recordâ action, which will take the value from the formula field and copy it to {PIT Spread}.

Iâm guessing that @Reid_Thomas is referring to something like a single select field, where you manually mark records as direct hires vs contractors. However, if the data itself can provide an indicator of which is whichâlike the {DP Fee} only containing data for direct hires and remaining empty for contractorsâthen you can save yourself the extra effort of manually marking each record and use that built-in logic to get the job done as I described above.