Hi
Thanks for replying. I am new to business central and al development. I am not able to comprehend the existing implementation. However, I am attaching my code snippet below of the cue table fields where I have to do the calculation. Please suggest whatever change is required in the code form.
field(2; "Previous Month - Global"; Integer)
{
FieldClass = FlowField;
CalcFormula = count ("Employee" where ("Office Location" = Filter ('GLOBAL')));
}
Requirement is to calculate number of employees with office location= Global, leaving the org to the total number of active employees in the org in the last month. Active status of employees is stored in the Employee table and number of left employees is in custom table named Employment.
Please suggest.
Thanks again
