I am trying to figure out a way to do what I am calling a "conditional Calculation"

I have a table for ALBUMs and a table for WRITERS. there are Many WRITERS for each ALBUM.

For each writer I specify a percentage ownership and assign them to either group A or group B

I would like a field in ALBUM to calculate total group A ownership and a field to calculate total group B ownership. This way when I pull up any album I will immediately see the percent owned by Group A and the percent owned by Group B ...For example.

Writer 1 - 10% - Group A

Writer 2 - 30% - Group B

Writer 3 - 20% - Group B

Writer 4 - 30% - Group A

Writer 5 - 10% - Group B

Total Group A Ownership = 40%

Total Group B Ownership = 60%

Any ideas?

Think I figured out a way to do it..

I just created 2 extra calculation fields for each writer.

1 called Group A % = if(Group ="A", %owned, 0)

1 called Group B % = if(Group = "B" , %owned, 0)

Then in the ALBUM table there is:

Total Group A = SUM(WRiters:: Group A%)

Total Group B = SUM(Writers::Group B%)

Still happy to hear ideas if you are so inclined