11.3.4 Values for Employee Expenses didn't match
I applied all formulas correctly and check the data loaded, having a correct validation, but still the amounts where different from those in the sample image.
Checking the data in EMP02 Employee Expenses, for the Line Item Left? I identified that for all employees withe a Leave Date, had this checkbox marked, even if the Leave Date is in a future date.
This is the formula I had:
Start Date <= 'SYS00 Time Settings'.Last day of Month AND ISNOTBLANK(Leave Date)
And modify it with the following formula:
Start Date <= 'SYS00 Time Settings'.Last day of Month AND ISNOTBLANK(Leave Date) AND Leave Date <= 'SYS00 Time Settings'.First day of Month
Now data for all Employee Expenses line items are similar to the sample image
Comments
-
Sure, this is the snapshot of the formula modified
0 -
Last time I checked I didn't have to add extra condition to it. I would say check if SYS00 Time Settings.Last day of month is populated and is working fine.
Honestly if you know what you are trying to achieve and you understand the formula construct - that's the real win. You might get one mark less in exams but as long as you clear it all good.
Thanks,
Misbah
Miz Logix
1