Can we use formula to calculate percentages

Ask the community
1

Here is a use case. I have two fields in a tab in airtable:

  1. Number field (Total seats) - which shows total number of seats available - lets say for example 100 seats available
  2. Number fields (Seats booked) - which shows how many seats are booked - lets say 75 for example (meaning 75 seats are booked0

What I want is the percentage of booked seats - in the above scenario it is 75%. How do we get this in softr?

2

In airtable make a formula field with (({Seats booked} / {Total seats})*100)&“%” and reference to it in softr. Do not let softr calculate things :slight_smile: let it be done in your database.

1 Like
3

Thank you, that should work