• BLOG
  • Pivot table quantity not adding up

    When I create table with summary of available quantity I find that the numbers do not match with the samples displayed in list view. Eg. In the list the samples would have quantities 0.2, 0.5, 0.2, 0.4. But in the pivot table the quantitiy becomes. 0.900000000000000001065… instead of just 0.9. I’ve gone back and tried to edit the quantities entered as 0.20, 0.50, 0.20, 0.40. But this does not solve the problem. Does anyone know what might be causing this?

    Hi @JudyC,
    Thank you for bringing it to our attention. This seems to be a bug occurring specifically for the display of pivot tables. I have logged a bug for this: OPSMN-5347. This is set to be fixed for OpenSpecimen version 7.1.