Create Variable from Table Sum Total Based on other field and other variable
I have the following:
1. A table, 'Orders', with a column 'X', values 'DlyOrders' and 'DlyBillings'.
2. A Master Calendar, column 'Cal_Date', comprising every date of the year. Orders and Billings return every day and are calculated for each date, example '2023-10-09'.
3. A variable, 'vMaxReportDate', being the maximum reported date of the 'Cal_Date' from the Master Calendar.
I need to assign to a new variable the sum total of orders where column X = 'DlyOrders' and the Cal_Date = vMaxReportDate.
I need to assign the new variable in the load editor.
