How Insert data in the blanks in the form how to use the formula?

[phornsophon]

Hello , community
The formula I am using can be reported as a table But can’t sum up the results in the blanks below the form.
I would like to summarize the results of the month-end equipment inspection, Insert the data in the blanks in the form, how to use the formula?

My English isn’t so great but I’ll try

Best regards

[Marc_Dillon]

In general, take the same expression that you used within the START, change the returned column to what you need, and wrap in an aggregation expression.

In your case, start with this:

You can ignore the ORDERBY, so your expression is simply [BKR AIS File PDF], which I assume is a renamed REF_ROWS VC of child records. So you can use “List Dereference” on this to get other columns from the Table. For example the max date would be

MAX( [BKR AIS File PDF][DateTime] )

or a sum of some column:

SUM( [BKR AIS File PDF][column] )

(I don’t know how you expect to sum a column with values of “Norma;” though…)

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.