Forum Discussion

rajasekar_o's avatar
rajasekar_o
Helper V
2 years ago
Solved

login based leave calculation

hi team, how to calculating leave  I have employee logindetails  EMPID LOGIN DATE TIME  SHIFT EMPS001 1/4/2024 6.00 am 1 EMPS002 1/4/2024 6.00 am 1 EMPJ003 1/4/2024 6.00 am ...
Need Help
Tips and Tricks
rajasekar_o's avatar
rajasekar_o
Helper V
2 years ago
AllEmployeeDays =
CROSSJOIN(
    'Emplv',
    'Calendar'
)
IT showing error

 

 

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi rajasekar_o -you have to create a calculated table using cross join funcion with Calendar and Employee tables to get a complete list of all employee dates that should have a login. 

     

    AllEmployeeDays =
    CROSSJOIN(
        'Emplv',
        'Calendar'
    )
     
    Please change or replace with your model level table names.