Forum Discussion

normanoh's avatar
normanoh
Qrew Member
8 months ago

How to Edit a Summary Field

I need to edit a figure that is in a Column that is "not editable" for some reason. The pop up stating "____ is a Summary Field. Summary Fields are not editable." Can anyone help?

Forms
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    8 months ago

    you cannot edit a summary field or a lookup field or a formula field.  But, if you need to have the choice to override  the value, you can make a new field called [Summary xyz override], (deselect treat blank as zero) and then have a new field called [Summary field final] with the formula

    IF(not IsNull([[Summary xyz override]),[Summary xyz override],[Summary field])