I would like to sum up all the columns and add this amount to a new/another column. The “column summaries” feature does this but I would like this number to added to another column. I tried using the equation field type but not able to figure out what would be the equation for this.
Hi @IT14,
In my example I have 4x number fields Qty A
through to Qty D
.
I then add an equation field that has this formula:
{Qty A} + {Qty B} + {Qty C} + {Qty D}
Hope that helps!