LinkedIn
Twitter
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
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…)
