Hi all FM Genius,
I have a table where I have as columns: Purchase_Month, p_SupplierName and c_Total from table::Purchases. I wrote an Executesql formula as follows:
"SELECT p_SupplierName , Purchase_Month, SUM(c_Total)
WHERE Purchase_Year = ?
GROUP BY p_SupplierName, Purchase_Month" ;
"" ; Purchases::Purchase_Year; Purchases::Purchase_Month )
and am getting the result as
All Goods Ltd:October:7328.3071186440677962