Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 13, 2023 08:23 AM - edited Sep 13, 2023 11:03 AM
Hi, I am creating a CO2 emission calculator on airtable and i can't seem to get my formula right.
The formula in question is:
({Émission véhicule en Kg single} + {Émission véhicule en Kg total} + {Émission repas en Kg}) / 1000
The formula either calculate using one destination ({Émission véhicule en Kg single}) or from multiple destinations ({Émission véhicule en Kg total})
In every case either {Émission véhicule en Kg single} or {Émission véhicule en Kg total} will be empty which result in the formula being:
(NaN + {Émission véhicule en Kg total} + {Émission repas en Kg}) / 1000
or
({Émission véhicule en Kg single} + NaN + {Émission repas en Kg}) / 1000
The formula for {Émission véhicule en Kg single} is:
{Litre d'essence brulé single}*{facteur d'émission en kg/l single}
The formula for {Émission véhicule en Kg total} is:
{Émission véhicule en Kg 1}+{Émission véhicule en Kg 2}+{Émission véhicule en Kg 3}
I have tried multiple things and nothing seems to work. Let me know if you have any idea how to fix this.
Thank you
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 15, 2023 04:43 AM
I’m on mobile, so am shortening your field names.
Try
IF({single}, ({single} + {repas})/1000, ({total} + {repas})/1000)
Reply
1 Reply 1
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 15, 2023 04:43 AM
I’m on mobile, so am shortening your field names.
Try
IF({single}, ({single} + {repas})/1000, ({total} + {repas})/1000)
Reply
