Summary from 2 table by Group


In my Employee card, I add Location, shift & Hour Rate 3 field. does anybody can show me how to write a query to get Total amount that are sum( Employee Absence.[Quantity] * Employee.[Hour Rate) but group by Employee.Location& Employee.Shift ?


Hi James,

From what I understand you need to look for a flowfield or a calculated field (C/AL)

Try with flowfield first !