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

Misbah

@CrisBap

Is that a query? If so, request you to post a snapshot

CrisBap

Sure, this is the snapshot of the formula modified

Misbah

@CrisBap

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

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…