Hello All,
Really appreciate some guidance on this and thanks in advance !
I have a table that has following fields
Table A ProjectID, DocumentTypeId, MemberID, MemberShare
Table B ProjectID, CurrentBudget
Query 1 ProjectID, SumofMemberShare, DocumentTypeId, MemberID
I have formula in a query that calculates the funding costs for each member.
MC: CCur(Nz(Sum([CurrentBudget]/[SumofMemberShare]*[MemberShare]),0))
There is a possibility that the DocumentTypeId can change, how can I in the existing formula add that criteria?
e.g.
Really appreciate some guidance on this and thanks in advance !
I have a table that has following fields
Table A ProjectID, DocumentTypeId, MemberID, MemberShare
Table B ProjectID, CurrentBudget
Query 1 ProjectID, SumofMemberShare, DocumentTypeId, MemberID
I have formula in a query that calculates the funding costs for each member.
MC: CCur(Nz(Sum([CurrentBudget]/[SumofMemberShare]*[MemberShare]),0))
There is a possibility that the DocumentTypeId can change, how can I in the existing formula add that criteria?
e.g.
ProjectID | DocumentTypeID | MemberID | MemberShare |
2001 | 1 | 9 | 4 |
2001 | 1 | 11 | 5.5 |
Sum of Member Share | 9.5 | ||
2001 | 5 | 9 | 3 |
2001 | 5 | 11 | 3 |
Sum of Member Share | 6 |