Error when displaying a decimal as a percentage


#1

Simple issue I would hope: When calculating a division of two numbers in a row, it correctly displayed the result in decimal format. When I tried to reformat the result as a percentage, it did not move the decimal point over by two. In other words, my 0.11 was converted to .11% vs 11%. How on earth does that happen and what is the workaround?


#2

In your formula that calculates the percentage, multiply the dividend by 100.

fx = ({Sub COR Fee} * 100) / {Sub COR Cost}


#3

It’s a long-standing issue with Airtable — one slightly complicated by there now being an installed base of code built around the erroneous behavior. Until it’s decided how best to address the issue, you’re probably best off with the multiply/divide by 100 workaround…


#4

That works - thanks!