Pivot Table like app

Need help
1

Hi fellow Bubblers!

I am creating an app that would allow us to upload a CSV and produce a Job Costing report. So we are breaking down employees pay per job. I am stuck on the very last field I need to calculate.

The very last field in in a table that is grouped by job name, in a cell I have a repeating group that has its own groupings.

Screenshot 2024-03-14 at 12.35.31 PM
Screenshot 2024-03-14 at 12.35.31 PM697×760 72.5 KB

I am trying to calculate the total amount paid to all employees for that specific job.

Screenshot 2024-03-14 at 12.37.59 PM
This is the formula I currently have to break out the pay per job.

The table now looks like this.

Screenshot 2024-03-14 at 12.39.17 PM
Screenshot 2024-03-14 at 12.39.17 PM480×948 52.1 KB

So all I need now is to add up all of the amounts in the cell and format it as currency, but I don’t see any way to add them up. Maybe I am missing something obvious?

I set the app to public and am using dummy data so here is the link if anyone would like to take a look.

Any help would be greatly appreciated.

Thanks!

2

I ve take a look.

first : the way you build the table will cause you a lot of trouble. With 10 rows of reports in your table will be ok, bu with hundred, the app will crash.

Unfortunalty there is actually no way to sum the total of a colum… In repeating groups you can but with a plugin :slight_smile:

3

Thanks for the reply! This seems like a glaring omission to the table element.

Do you happen to know the name of that plugin? I can try rebuilding it with RGs.

Thanks!

4

Table element is still under beta :confused:

I really advice you to put an hundred dummy data in your table to see how the app respond but pretty sure it will crash.

5

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