Here’s the formula I’m using:

IF(

{Number Field 1}!=’’,

({Number Field 1} / {Weight (number field)} + {Number Field 2}),

IF(

{Number Field 2}!=’’,

({Number Field 1} / {Weight} + {Number Field 2}),

‘’)

)

My goal with the formula:

I’m trying to reach an inventory count as a result of this field.

A) If the inventory count is low, we can manually enter the exact count of the part into “Number Field 2”

B) If the inventory count is higher, we get an approximate count based on weight. So we enter the weight into “Number Field 1” of the total part. It calculates total weight vs the part weight to give us a part count.

C) If for some reason during the process we weigh the inventory, but find more of that part, we sometimes add the exact count on after. So if there’s numbers in each of the field, we need the formula to account for both.

The result of the formula “works”, as in the numbers are right. But it isn’t a number output. So for us to use the result of the field, or format the output, it isn’t working for us.