I can’t see a way to do this so presume I am missing something.
So here I need to see the average value of a call booked which is different than the avg cash collected per closed call. I want to see Total cash collected divided by total calls booked.
How can I make this show on an interface?
I think its a bit bonkers you can’t just do a simple sum on an interface with the figures of that interface. Am I missing something or is this actually not possible?
Help much appreciated. Cheers
+31I don’t think you’re missing anything I’m afraid
My workaround for this involves creating another table where I do those calculations and then displaying those values instead. Needs an automation to link the data records to a single record in that new table so the calculations are kept up to date
Hopefully someone else has a better idea!
+8A potential workaround is to make sure every booked call has a numeric value in the “Cash Collected” field — i.e. default it to 0 for calls where nothing was collected yet. The reason is Airtable’s Interface number field AVERAGE ignores blanks, so if uncollected calls are empty they won’t be included in that calculation.
If you set uncollected calls to 0, then the interface Average becomes:
total cash collected ÷ total calls booked
because it’s averaging across all booked calls, including the ones with 0 in the field
I think you are just a Formula column short of making it happen TBH. Add a Formula column to your base with this formula: [Total Cash Collected]/[Total calls Booked].
Afterwards you can have that column be shown on the interface.
If you had a very very complicated formula in mind, I would have suggested a Mix of potential “rollup columns from a log table” and “AI columns” to handle complex math logic that would need operators the formula column doesn't support. But I think the formula column can handle what you have in mind.
Hope this helps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.