Active employee calculation
Hi Anaplan community,
I am facing a problem and need help. I created a line item (Active?) to define whether the employee is active or not. The formula that I used is:
IF PERIOD('DAT04 Employee Data'.Leave Date) < ITEM(Time) THEN FALSE ELSE IF PERIOD('DAT04 Employee Data'.Start Date) <= ITEM(Time) THEN TRUE ELSE FALSE
I get no error message but in some cells, I should see checked booleans. But none of the booleans are checked. The formula and the module that holds the data can be seen in the following screenshots.
Any help is appreciated.
Thanks in advance,