0

Accumulated by Staff Problem

I have a Problem on Accumulated by Staff fórmula. 

Example Marianela have 110 hours (104 normal + 6 overtime) but only sum 104 on the Accumulated by Staff. 

Some help

2 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    You need to figure out why it is not adding the overtime hours.

    let vDate := Date;
    let vStaff := Staff;
    let vBefore := sum((select Carga_Horas)[Date <= vDate and Staff = vStaff].Hours);
    let dBefore := sum((select Carga_Horas)[Date >= vDate and Staff = vStaff].Overtime);
    let result := vBefore + dBefore;
    styled(text(result), if text(result) < 0 then "red" else "green" end, "")
    

    The filters in line 3 and 4 do not look the same.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred Thanks Fred Ready 👍

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 32Views
  • 2 Following