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
JoeGoodhart's avatar
JoeGoodhart
Qrew Member
5 years ago

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.



------------------------------
J G1987
------------------------------
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago

With "Z", are you trying to calculate the % of Total Project that the Impact Value represents?



------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------