Forum Discussion

JoeGoodhart's avatar
JoeGoodhart
Qrew Member
5 years ago

Use field value from one record in a formula field for all other records in same table.

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 n...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

For 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?



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------