Solved: Pivot Table Is Not Consolidating

[BravesPiano5]

I'm not certain what the issue is but attached is my workbook (this is an example...what I actually have is large and confidential). Basically, why is the "Rate" row getting separated and not combining? It's showing duplicate "rate" rows rather than having one line per rate and the sum of the cases/allowance...I've tried everything:

• Ensure there are no unnecessary characters (i.e. spaces, blanks, apostrophes, etc.)
• Convert all data to text
• Remove everything except the pivot columns

I'm at a loss...I know the issue itself isn't entirely VBA (although I do have a macro which creates reference points and then consolidates the data into a pivot) but again I've tried everything.

[mdmackillop]

It looks like some floating point thing; values are not quite what they seem. Doing an Edit/ReplaceAll on each value removes the duplicates.

[BravesPiano5]

Agh!

I did a manual calculation and just automatically assumed since it evened out perfectly to 2 decimals that it wasn't a rounding issue. I've updated my VBA code to have that column round to 2 decimals.

Thank you!!