When you say you're 'fixing' the value, you can use LOD calculations which allow you to aggregate your values to certain dimensions.
If you could upload the workbook, then we can use it to show you.
Thank you for responding so quickly and being willing to assist me. I need to clean the data first and make a generic copy. Then I plan to upload the workbook. I may need to create a different thread and attach there as currently this reply box does not have the advanced options on the top right. I did see it earlier, I attempted to post and it told me I could not post on this thread.... Strange. Anyway Thank you again. I will try tomorrow and advise if I was successful in posting the workbook.