I'm looking for a more advanced calculation to achieve the following:
App 1: Multiple items per client, each item stating the time spent on that request
App 2: 1 item per client that states how much time this client is allowed each month
I'd like to add a new field to App 2 that shows how many hours they have left for that month (by finding all items in App 1 for this particular client, adding the together, and subtracting them from the total).
Thanks for all your help!
Please sign in to leave a comment.