Hi All, I would like to group and sum by fields dynamically in an AX while statement. Basically I want to sum and group by any field on the table using a setup table. Example:
while select sum(qty) from projinvoiceempl
group by CategoryID
{
//Some code which does some stuff with the qty sum
}
i would like to :
while select sum(fieldID of sum) from projinvoiceempl
group by (fieldID of category code)
{
//Some code which does some stuff with the qty sum
}
Is this possible?
Many thanks,
Shaakera
