Sum various columns in a subtable


#1

Hi there,

I would like to sum more than 1 column in a Subtable.

Let


#2

Let’s say I colums C with quantities and also column D have some quantities.
I already know how to sum quantities from column C, but I also want to calculate quantities of column D.

Screenshot


#3

Hi,

Please create a numeric field in D24 and apply it with formulas D20.
Remember to apply for the formulas recalculation once the formulas added.


#4

Hi Angie,

Maybe I am doing something wrong.

When I choose the field I want to make the SUM of the above cells, I can’t insert a formula on the Field Settings.

Please check the 2 images bellow:

Image shows the D27 cell I want to make the SUM

Image show there is no Field Settings because there is no filed setected.

Thank you.


#5

Hi,

You’ll need to type in the field name to create the numeric field first. Then, apply the formulas.


#6

Hi Angie,

If I do that, the total will appear on the E31 cell, corretc?

I would like it to appear on the D31 cell.

Thank you.


#7

Hi,

Currently, you’ll need to have a field there first in order to apply formulas.

A workaround would be as below:

Step 1. Span (merge cells) your “#Pallets/Master Box” field from D27 to E27.
%E5%9C%96%E7%89%87

Step 2. Create a new numeric field in D27 and apply for the formulas
Then, the result would be in E31

Step 3 Tune the column width of the D column so that you won’t see the field title


#8

Hi Angie!

Understood. I will use the workaround.

Thank you.