on 01-26-2015 5:07 PM
Dear Expert,
My client would like to view no of unpaid leave as a deduction amount in a different wagetype.
To date, I've manage to get the pcr working to get the daily unpaid rate, but I am unable to multiply the rate with the daily rate given in my pcr.
appreciate if there is any help
below is my PCR
calculate unpaid leave - Z014
Z014
*
****
ADDWT * OT Output table
3
1000 Basic Salary
OUTWPPERSG EE group in v.key
*
ADDWT * OT Output table
AMT*12 Multiplication
AMT/KZYEAR Division
ADDWT 3570 OT Output table
Z015
*
****
ADDWT * OT Output table
3
3560 Unpaid Leave (Days)
AMT= 3570 Set
MULTI ANA Multipl.amt/no/rate
ADDWT 3561 OT Output table
absences wt = 3560
unpaid leave for 1 day = 3570
I'm getting the daily rate 32.88 in IT table and unpaid leave 6 days in IT table..but in Z015 i couldnt get the value of WT 3570 when i use amt= 3570
appreciate if there is any help given. thanks
Hi,
Are you getting the amount in WT 3570 in output table of PCR Z014?
If yes then check that WT3570 is processing EE subgroup 3 or *? -- Share the output details of PCR Z014.
If in the output table WT3570 is carrying EE subgroup is "*" then you have to modify your PCR Z014 & Z015 for further calculation. In Z014 pcr you will add operation ADDWT&357A after ADDWT 3570. Then in the Z015 pcr you will call the AMT=& 357A (after "&" give one space) instead of AMT= 3570.
If it's processing with EE subgroup 3 then check are use the correct syntax for amt. it would be
AMT= 3570(need two sapce after =).
Regards,
Sankarsan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
From your PCR, I must assume that in the Input Table to Z014, WT 1000 exists with an Amount, and WT 3560 exists with a Number. Please confirm.
Try using a temporary variable instead, as it is sometimes hard to read a WT that does not have the same splits.
Z014
* ****
ADDWT * OT Output table
3 1000 Basic Salary
OUTWPPERSG EE group in v.key
*
ADDWT * OT Output table
AMT*12 Multiplication
AMT/KZYEAR Division
ZERO=& 3570 (To clear the variable before it is created)
ADDWT&3570 (Output to temporary variables table)
Z015
* ****
ADDWT * OT Output table
3 3560 Unpaid Leave (Days)
AMT=& 3570 (With a space between & and 3570)
MULTI ANA Multipl.amt/no/rate
ADDWT 3561 OT Output table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In the PCR, WT will be processed in the same order as they appear in the Input Table, and when processing a WT it is sometimes hard to "read" information from an other WT if it has not been processed yet or if the 2 WTs do not share the same "splits".
In your example, WT 3560 will be processed before WT 3570, and they do not have the same splits. So what I would do would be to create a temporary variable when processing WT 3560, and use that temporary variable when processing WT 3570, as in:
3 3560
ADDWT * ADDWT&3560
3 3570
ADDWT * NUM=& 3560 MULTI NAA ADDWT 3561
Note that if you have more than one instance of WT 3560 in the Input Table, it's Numbers will be totaled in the temporary variable.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.