I’m trying to create a Display Label with a calculated value from a specific Table column that is populated based on an SQL query. The query uses a where clause based on a calendar, so anyone can select a date on the calendar to populate the table. I’d like to totalize the values of one column and display this on screen. One factor to consider is that the number of rows in the column can change from day to day.
Can anyone help with a possible solution?
below is the SQL query I’m using to populate the table:
“SELECT make, start_time, t_stamp, type, vat, temp_avg, silo, weight, bf_sp, bf_avg, pf_sp, pf_avg, cream_total, cream_add
FROM cheesemake
WHERE (start_time != “”) AND (start_time>’{Root Container.CalendarMinus2Hrs.date}’) AND (start_time<’{Root Container.CalendarPlus16Hrs.date}’)”