Summary from 2 table by Group

Dynamics 365 Business Central/NAV Developers Forum
#1

Hi,

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 ?

Thanks

#2

Hi James,

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

Try with flowfield first !

g.