Project Table < Impact Table
Related Project Table Record #1 in Impact table has a formula field 'X' that results in a currency value. (the other records have this field too, but purposely have no value)
All other related Project Table Records in Impact table have a formula field 'Y' that result in a currency value (the record #1 has this field too, but purposely no value)
What I want to do is create field 'Z' in project impact that has a formula of [Y/Sumof X], to result in a % value. I have created the summary field for field 'X'.
I am getting null value.
I've tried to relate a 3rd table to make it work, where both Project table and Impact table are parents of 3rd table. But, still won't work.
------------------------------
J G1987
------------------------------
