I made a database for all my submitted job applications and I’m tracking two things in a dynamic report: interview count and an interview rate. The interview rate is the percentage of job applications I got an interview from. I use to track this data in a spreadsheet. In the spreadsheet, I used this formula to determine the interview rate:

```
=(SUM(E2:E1000) / COUNTIF(A2:A1000, "*")) * 100
```

Row E has an “interviewed” section with a value of either 0 or 1 (1 being I had an interview) and Row A has a company name. This formula sums up Row E, divides it by the number of all Row A cells that have a value in it, then multiplies by 100. This worked fine in Calc, but now that I’m using Base, it’s a bit trickier. Any help would be much appreciated.