M
msprick
TI
I need to calculate the ratio of a client's 30 day projected income against the poverty level adjusted for family size
30DayProjectedPovertyLvl: [Sum30DayProjectedWage]/((([Status]![NumInHousehold]-1)*[PovertyGuidline]![PerAdditionalMember])+[PovertyGuidline]![1FamilyMember]
The formula works but I need it to have the expression use a foriegn key (Year) in the Status table, find the coresponding primay key in the PovertyGudline table and use the appropriate values for PerAdditionalMember and 1FamilyMember
How do I do that
Michael
I need to calculate the ratio of a client's 30 day projected income against the poverty level adjusted for family size
30DayProjectedPovertyLvl: [Sum30DayProjectedWage]/((([Status]![NumInHousehold]-1)*[PovertyGuidline]![PerAdditionalMember])+[PovertyGuidline]![1FamilyMember]
The formula works but I need it to have the expression use a foriegn key (Year) in the Status table, find the coresponding primay key in the PovertyGudline table and use the appropriate values for PerAdditionalMember and 1FamilyMember
How do I do that
Michael