07-26-2022 10:26 AM - last edited on 05-03-2023 09:33 AM by JackLacava
One employee was terminated in June; however, calculations are being done all throughout the year (1-12). Should be zeroed out from July to December. (In Plan Reports) How do I ensure that calculations are made from January to June, but zeroed out after July until the end of the year?
07-26-2022 02:29 PM
What about your execution list, is the status of the employee a Term?
07-26-2022 03:55 PM
I only have two execution lists; Active and Term.
07-26-2022 04:46 PM
Is the employee flagged as the term, and is the termper updated?
07-26-2022 04:50 PM
The employee is flagged as term and the TermPer is updated to 6 under the drop-down.
07-26-2022 04:51 PM
I keep running into more issues though.
07-26-2022 05:00 PM
You do have more parenthesis in there. There could be a lot of things involved. It could be that you don't have a space for AND in the conditional expression, or everything in that expression is failing unless you show the employee screen. This is a guessing game. Another thing you can do is just enable Term only and see if something is calculated.
07-26-2022 05:20 PM
Yes, there is just an open parentheses ( missing before the xfcell.
07-27-2022 10:09 AM - edited 07-27-2022 10:09 AM
The plan is calculating but not the way I was expecting it to. In Plan Reports in the first screenshot, you can see calculations being made throughout the entire year, but it should stop calculating (zero out) after June because that's when they were terminated.
In 2nd image, the employee is flagged as ‘Active’ because when it is flagged as ‘Term’ it will NOT appear in Plan Reports at all. How can I fix that in order to show that one ‘Term’ employee?
07-29-2022 12:38 PM
Since you flagged it as Active, those are calcs that are running. You have two options either change the Active calc conditional to see if there is a TermPer and stop it or change the report to show Actives and Terms.
07-26-2022 05:21 PM
You also should test the type of the account.