Qrew LegendFor this issue here
I have created the summary field for field 'X'. I am getting null value.
Have you set the field properties of that Summary field to "treat null as zero". What is the value of that field in the "other" records. Do they all calculate to null or to zero?
Hello Mark,
I had not had the summary field for 'field x' checked as 'treat null as zero'. I have since checked that box, but no change. Still blank values coming back for that 'summary field of 'x''.
The 'X' field does in fact have a value for 4 of the records in the table.
Thanks for the help.
With "Z", are you trying to calculate the % of Total Project that the Impact Value represents?
Yes, but... 'Total Project' is represented by 'record 1' in the table. So, yes, % of 'record 1' that the Impact Value of each other individual record represents
Qrew LegendI believe that you will need a second relationship so that all of the children are related to Record ID number one in Projects.
Try creating a field on the Child Impact Table with a formula value of 1 and create a new relationship back to the project record. Then the look up that field for that summary total down to all Impact records.
The issue is that you have a value on Project #1. But other than that special Impact record, none of the rest of your Impacts children are connected to project #rom so the lookup form Project #1 for that Total field field will be null. (which you proved!). So we make a second relationship so that every child record is attached ot that special project w/ Record ID# of 1.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
