I have a table with the following fields:

• Capacity Required - a number 
• Capacity Provided - a roll up sum of a linked record
• Gap Remaining - the delta between Capacity Required and Capacity Provided

I have another field called Status that looks at the Gap Remaining and provides a single select option 

The following are all nested, so will be triggered in order: 

• If the gap remaining is negative, the status is "overstaffed"
• If the capacity required was 0 to begin with, the status is "N/A"
• If gap remaining is 0 the status is "fully staffed"
• if the gap remaining is less than the capacity required the status is "partially staffed"

The status field behaves as expected for 1207 records in my table. But now I have a record where when the gap remaining is 0 the status is partially staffed...if and only if one of the values being rolled up is ".10" and only for one specific record. If I change the value from .10 everything works, putting a .10 value in a different record also works fine. I'm including screen shots to show this. 

I have no idea what is happening and no idea how to fix it short of something super hacky in my nested if statement that checks for this one, very very very specific case and sets the status correctly.