Yes the calculation result is accurate. The problem is with the .48 result rounding down to 0

I am pretty sure the calculation is correct. At least it is returning the correct result

for example:

[Number of Records]/3*8760/[MTBF]/4

4495/3*8760/70000/4 = 46.87 which is the same as the result of the calculation in tableau.

I tired what you suggested but it doesnt work. My [Rounded Quarterly Failure Rate] is now returning the actual number of records for each model number. i.e 4495.

I have attached the workbook so maybe it makes more sense.

Thanks for digging into this Alex. Good catch on the duplicated data. Got that fixed.

I see that the SUM is actually what is giving the correct results on sheet 1 and I guess that is why my simple +1 calculation doesnt work.I think the issue I am having is that I need to SUM the number of records of each model and then divide by the non SUM of MTBF. I cant figure out how to do that. It always says I cant mix aggregate and non-aggregate arguments in a function.

Any other ideas?

Thanks

Think i figured it out

[Quarterly Predicted Failure Rate] = SUM([Number of Records])/3*8760/MAX([MTBF])/4

[Rounded Quarterly Failure Rate] = IF [Quarterly Predicted Failure Rate] < 1 THEN 1 ELSE [Quarterly Predicted Failure Rate] END

Then I just set the number format to 0 decimals

Thanks for taking a look Alex