I am building a simple report for incoming apartment communities to our company, and I have included a formula column to divide the deal value by the number of units for each property so we can see what our fee per door is. However, I need what is currently showing as N/A to display the weighted average. I know this is not possible as that ‘cell’ is only tied to the formula column.
Does anyone know of a workaround? I would like to show the total weighted average in the table, but if it has to be a widget, I’ll take that as a plan B.
All I want to do is divide $1,431,253 by 2072!
Please help!
