I'm reading in an excel file to extract an interest percentage. Due to the format I receive the file in, I'm using a substring extractor to remove the % sign and then dividing the number by 100 to get in the proper format. It looks like between the excel file and the arithmetic editor, the number is being rounded up. Anyone know how to prevent this? Screenshots of original excel and inspector results provided. The number in the screenshots I'm focusing on is 98.517% changing to 98.520 - 0.98520.
Be the first to reply!