cancel
Showing results for
Did you mean:
Helper III

Calculate Leave day in Leave request

Hi All,

I want to create leave balance day for each staff, Leave day per year: 12 day
How can i calculate the remain leave day of each staff, i tried like this but it doesn't work:

Remain day = 12-count([left day]

How to put correct value in Formula?

Thanks so much

2 REPLIES 2
Super User III

@NguyenHuu I assume 'Date Left' is a number field.

Can you try

=[Column1]-[Column2]

The new column should have the correct value.

I hope it helps.

Helper III

Hi @CFernandes ,

Thanks for your feedback, but the New date ( each staff have available leave date per year: 12) will calculate like this:

- First request 2 day leave--> Available for next request= 12-2=10

- Second request 4 day leave-->  Available for next request = 12-( 2+ 4) =6

so how can we count total date at Date left to calculate the Availabe leave day for staff ?

as i tried like this: 12-count[Date left] but it wrong, how to put correct ?

Thanks

Announcements

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Top Kudoed Authors
Users online (979)