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

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
    ------------------------------
    • 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/
        ------------------------------