Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am having following table:
Temp:
load
PAYCODE,
L01_ADD as Total_CL,
L02_ADD as Total_SL,
L03_ADD as Total_EL,
application_no as App_No,
request_id as Request_ID,
leave_from as Leave_From,
leave_to as Leave_To,
leavecode as LeaveCode,
leavedays as NoOfLeaveDays
//if(leavecode='CL', sum(leavedays),'0') as [CL Accrued]
Resident LeaveLedger;
Now, I need to do some expression calculation at back end, I am trying with some expression but it gives me error.
I need to calculate following fields at back end in this table:
Accumulated Casual Leave= sum(Total_CL)
CL Accrued=if(leavecode='CL', sum(leavedays),'0')
Closing CL Balance= Sum(Total_CL)-if(leavecode='CL', sum(leavedays),'0')
Please suggest, if possible at backend.
Regards,
Balraj
See attached qvw for calculation of the XX_Accrued fields.
I have no idea what Accumulated Casual Leave = sum(Total_CL) is supposed to be. For paycode 3001 the sum of Total_CL is 5782. Surely that cannot be a number of leave days?
True, It is not number of leave days.
Total_CL is a static field which holds the predefined leave balance for a particular paycode.
Gysbert,
I am not able to download this file, showing "failed to open this file".
Try again. Or try again using a different browser or from a different computer. I can download it without problems.