# Calculate lookups on the front end (based on filters)

**URL:** <https://community.fibery.io/t/calculate-lookups-on-the-front-end-based-on-filters/8257>\
**Category:** Ideas & Features\
**Created:** [February 12, 2025, 11:18am UTC](https://community.fibery.io/t/calculate-lookups-on-the-front-end-based-on-filters/8257 "2025-02-12T11:18:15Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [February 12, 2025, 5:11pm UTC](https://community.fibery.io/t/calculate-lookups-on-the-front-end-based-on-filters/8257/4 "2025-02-12T17:11:05Z")

</div>

I think this feature request is tied to the general concept of having calculations function as a part of views not as a formula field at all.  
The current solution would be to create many formula fields that calculate various conditions to match a fixed set of filters. For example I have a formula that calculates the number of active sub articles in my Company manual and I display it on list views:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/d20eb2419b6726af87862dbb8b77011c0a1fa584.png)

We’re really looking to recreate the common function in competitor tools of aggregating data about the entities in view (Sum, Avg, Count).  
There’ve been several requests through the years that relate

> [@Formula fields that are filtered by the context they're viewed in](https://community.fibery.io/t/formula-fields-that-are-filtered-by-the-context-theyre-viewed-in/6623/5):
>
> Aggregations by row/column in board view would likely cover many of the situations I’m thinking of. My only issue with aggregations on table view is that they can’t be filtered. Here’s a request I made a few weeks back about it: [Allow specific databases to be excluded from column calculations](https://community.fibery.io/t/allow-specific-databases-to-be-excluded-from-column-calculations/6513) I usually default to formula improvements being an ideal solution because the more they get improved the more flexibility and autonomy all your users have to customize their workspaces themselves without …

> [@Kanban view columns & formulas](https://community.fibery.io/t/kanban-view-columns-formulas/3695):
>
> Hey guys, Not sure if doable or not but would it be possible to allow defining custom formulas allowing to compute specific indicator based on Kanban columns content? Computed value could be located under the column title (close to the count information when displayed). Cheers.

Which is also linked to [Kanban board details - WIP Limits](https://community.fibery.io/t/kanban-board-details-wip-limits/328)

[Fibery makes us choose between views which allow us to edit and interact with the entities, and reports](https://community.fibery.io/t/transposed-table-view/8197/4) which aggregate information about the entities and their properties. This is a hard transition when coming from other tools which do not offer powerful reports and so have lightweight aggregations inside the views. I think there are clearly many cases for why in-view calculations should be functions of the view and not a part of the data model.

---

_[View the full topic](https://community.fibery.io/t/calculate-lookups-on-the-front-end-based-on-filters/8257)._