Simple Table: Calculating Department Totals and Employee Compensation

[Ananya Sharma]

Hi community,

In our quarterly performance report, we maintain a table with columns for Department, Employee, Hours Worked, Hourly Rate, and Bonus (%).

I’d like to automatically calculate:

• The Total Compensation for each employee (Hours Worked * Hourly Rate + Bonus),

• The Average Hourly Rate per department,

• And the Total Compensation per Department.

Finally, I’d like to group the table by Department so that each department shows its subtotal and average values at the bottom of the group.

Is this possible directly inside Simple Table without exporting the data to Excel?

[Tomislav Tobijas]

Hi @Ananya Sharma ,

I haven't used this app, but I believe @Mia Tamm _Simpleasyty_ works for the vendor and could potentially help out with this.

Additionally, on the Marketplace app listing, there's a Support tab where you can find contact details to reach out to the vendor's support team directly. I'd say this is the recommended way to ask for help when it comes to third-party apps such as this one, as support teams are usually quite responsive and are willing to help.

Cheers,
Tobi