how to use calcfields

viswanath · 2008-01-02

hai all

i calculated the total absences(flow field) of an employee with the filters employee no and month.
and i want to use this flow field to calculate the paid days(total days per month - employee absences for that month)
i know that flow fields are virtual fileds , and tried with calcfields function to update
but unable to worked it out
can any one help me in this senario
Thanks in advance

kine · 2008-01-02

For that you cannot use flowfield. You need to use function for that. You need to take count of workdays in the month and subtract the absence.

kriki · 2008-01-02

If you use it directly on the table in which the data is, you need to use CALCSUMS(...);

E.g.

recAbsences.RESET;
recAbsences.SETCURRENTKEY("The Key you need");
recAbsences.SETRANGE("Employee No.",codTheEmployee);
recAbsences.SETRANGE("Some Date",datDateFrom,datDateTo);
recAbsences.CALCUMS("Absence Field");
MESSAGE('The employee has been absent for %1 days',recAbsences."Absence Field");

If you have a flowfield in Employee that points to this table, you need to do this:

recEmployee.GET(codTheEmployee);
recEmployee.SETRANGE("Date Filter",datDateFrom,datDateTo);
recEmployee.CALFIELDS("Absence Field");
MESSAGE('The employee has been absent for %1 days',recEmployee.Absence Field");

[/code]

kine · 2008-01-02

Kriki, it is about something else... :whistle:

kriki · 2008-01-02

kine wrote:

Kriki, it is about something else... :whistle:

I just continued on the information that was provided. That let me think there was a field with a decimal in it to be totaled over a larger period.

Or maybe I didn't recover from the End-Year-Party.

how to use calcfields

Comments

Categories