Hi, I’m looking to create a custom view from a table that will display a summary of data for each month.
Firstly, I want to select only rows from Table A where the Table B field has the value “Example Value”.
Then, I want to calculate certain sums based on subsets of the “Example Value” rows:
I want to calculate a “i.e Staff Hours” value for the given month, which is the sum of “hours” multiplied by 8 multiplied by the number of business days in that month.
I also want a “i.e Work Hours” field, which is found by taking the sum of hours for rows whose “i.e Work Status” field is not “i.e Full-Time Employee”.
I also want a “i.e Senior Staff Hours” field, which is calculated by summing hours for “Table A” where the “i.e Proficiency Level” of Table B is 4, then multiplying by 8, and then multiplying by the number of business days in that month.
Is there a way to do a custom view instead of making a script?