Forum Discussion

ZacharyStein's avatar
ZacharyStein
Qrew Member
2 years ago

Re: Lookup a value with multiple conditions into a field in a separate table

Thank you so much for your reply!

Yes the tables are related.  It is a many to one relationship where the forecasts table is many.  When I create a new field what field type would I use?  I don't see an option for summary fields. 



------------------------------
Zachary Stein
------------------------------

1 Reply

  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    2 years ago

    You don't set the type for a summary field - it's determined automatically based on the type of data you're summarizing. So if lets say you're summarizing the 'total forecast' it will likely auto-determine that is a numeric field and create accordingly. 



    ------------------------------
    Chayce Duncan
    ------------------------------