11.3.4 Values for Employee Expenses didn't match

CrisBap
CrisBap
in Academy Discussions

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
    Misbah

    @CrisBap 

     

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

  • CrisBap
    CrisBap

    Sure, this is the snapshot of the formula modifiedTemp1.png

  • Misbah
    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

Categories