Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
Self-hosted
What do you need help with?
Hello everyone,
I am faced with the challenge of calculating my consumption from different household meters.
I have a table with all the meter readings from the electricity and water meters.
In another table, I would now like to calculate the consumption for e.g. the water meter of a certain year in a field.
The meter table looks like this:
ID | Meter type | Meter ID | Meter reading | Meter reading date
The formula should now search for the meter readings of a specific year in the meter table and calculate the consumption. To complicate matters further, the meters were/are replaced during the year. This adds the meter ID as a variable.
I have imagined this as follows:
- search for all values for a specific year of a meter type (example: 2024, water meter)
- are there several meter IDs? If not, calculate the delta between the smallest and largest value. If yes, calculate the delta between the smallest and largest value for each meter ID and sum them all.
Is this possible?
BR
