I have a formula colum to calculate the net profit percentage in my business. The totals row/bottom line for that column is showing as zero. I have changed the unit to % and the fuction to average but it still won’t provide that average.
Here is my formula for the function column if that is relevant.
concatenate(roundup(((1-(DIVIDE({Expenses},{Revenue})))*100),1),“%”)
Can anyone provide some advice to get it to show that average?
Hi Nick,
Your formula doesn’t produce a number but a string of characters, that’s why you can’t average it.
Remove the concatenate part. If you want a number followed by a percentage sign, that’s not the proper way of doing it. Rather select % for unit in the summary and you’ll see that the average will work.
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.