Getting average out of totals

Hello guys,

I am brand new to Bubble. I am trying to show the average on the page. Here is my database setup -
image

on the front end, I want to show the average of the total salary. I tried using the math.js plugin after going over forums here but I am not able to solve this after so many attempts.
image

The number that you see $90, 697/yr is where I want to show the average salary. I understand the formula to calculate average but not sure how to apply it here.

Please help me with this! Appreciate any help with this.

1 Like

What you can do is use the equation a+b+c divided by the amount of variables, times by 100. Eg a+b+c/3*100. That will get you the average.

1 Like

If your db-field is a number you can use average (or sum, product, median etc) directly.

1 Like

Thank you so much Anders. :pray: This worked!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.