cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NguyenHuu
Helper III
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]

a.PNGb.PNG

 
 

How to put correct value in Formula?

 

Thanks so much

 

2 REPLIES 2
CFernandes
Super User III
Super User III

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

 

Can you try 

 

=[Column1]-[Column2]

 

 
 

Untitled.png

 

The new column should have the correct value.

 

Untitled.png

 

I hope it helps.

 

 

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

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.

PowerPlatform 768x460.png

Microsoft Learn

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

Users online (979)