Skip to main content
SharePoint

Return to Question

added 63 characters in body
Source Link
Gracy
Gracy
  • 95
  • 2
  • 6

I have 4 columns Leave Type, PTO Available, Calculated days, Current PTO YTD. Leave Type is a drop-down boxLeave Type, PTO Available, Calculated days, Current PTO YTD. Leave Type is a drop-down box which is having different types of leave like casual leave, sick leave, marriage leavecasual leave, sick leave, marriage leave.., like this.

And also PTO AvailablePTO Available is the column which company gives some leaves for employee in a year like casual leave in a year=18 days, Sick leave=10 days like that default holidays.casual leave in a year=18 days, Sick leave=10 days like that default holidays.

And my Calculated daysCalculated days is the column which he will take leaves with comparison of Start Date and Return Date,comparison of Start Date and Return Date, which is a calculated column.

So,now my requirement is I have to take Current PTO YTD has a calculated columnCurrent PTO YTD has a calculated column with different conditions like,

If Leave Type=Casual LeaveLeave Type=Casual Leave then I have to compare the field casual leave in PTO Available and I have to subtract the calculated days of that particular column and the result should be in Current PTO YTD.compare the field casual leave in PTO Available and I have to subtract the calculated days of that particular column and the result should be in Current PTO YTD in Current Casual Leave PTO YTD .

Likewise, if Leave Type=Sick Leave the I have to compare the field Sick leave in PTO Available, I have to subtract the calculated days of the particular column andif Leave Type=Sick Leave the result should be in Current PTO YTD.I have to compare the field Sick leave in PTO Available, I have to subtract the calculated days of the particular column and the result should be in Current PTO YTD in Current Sick Leave PTO YTD.

And also I have to exclude Saturdays and Sundays in calculated columns?

I have tried but no result. Can anyone help me in this issue?

I have 4 columns Leave Type, PTO Available, Calculated days, Current PTO YTD. Leave Type is a drop-down box which is having different types of leave like casual leave, sick leave, marriage leave.., like this.

And also PTO Available is the column which company gives some leaves for employee in a year like casual leave in a year=18 days, Sick leave=10 days like that default holidays.

And my Calculated days is the column which he will take leaves with comparison of Start Date and Return Date, which is a calculated column.

So,now my requirement is I have to take Current PTO YTD has a calculated column with different conditions like,

If Leave Type=Casual Leave then I have to compare the field casual leave in PTO Available and I have to subtract the calculated days of that particular column and the result should be in Current PTO YTD.

Likewise, if Leave Type=Sick Leave the I have to compare the field Sick leave in PTO Available, I have to subtract the calculated days of the particular column and the result should be in Current PTO YTD.

I have tried but no result. Can anyone help me in this issue?

I have 4 columns Leave Type, PTO Available, Calculated days, Current PTO YTD. Leave Type is a drop-down box which is having different types of leave like casual leave, sick leave, marriage leave.., like this.

And also PTO Available is the column which company gives some leaves for employee in a year like casual leave in a year=18 days, Sick leave=10 days like that default holidays.

And my Calculated days is the column which he will take leaves with comparison of Start Date and Return Date, which is a calculated column.

So,now my requirement is I have to take Current PTO YTD has a calculated column with different conditions like,

If Leave Type=Casual Leave then I have to compare the field casual leave in PTO Available and I have to subtract the calculated days of that particular column and the result should be in Current PTO YTD in Current Casual Leave PTO YTD .

Likewise, if Leave Type=Sick Leave the I have to compare the field Sick leave in PTO Available, I have to subtract the calculated days of the particular column and the result should be in Current PTO YTD in Current Sick Leave PTO YTD.

And also I have to exclude Saturdays and Sundays in calculated columns?

I have tried but no result. Can anyone help me in this issue?

Source Link
Gracy
Gracy
  • 95
  • 2
  • 6

Calculated columns in SharePoint?

I have 4 columns Leave Type, PTO Available, Calculated days, Current PTO YTD. Leave Type is a drop-down box which is having different types of leave like casual leave, sick leave, marriage leave.., like this.

And also PTO Available is the column which company gives some leaves for employee in a year like casual leave in a year=18 days, Sick leave=10 days like that default holidays.

And my Calculated days is the column which he will take leaves with comparison of Start Date and Return Date, which is a calculated column.

So,now my requirement is I have to take Current PTO YTD has a calculated column with different conditions like,

If Leave Type=Casual Leave then I have to compare the field casual leave in PTO Available and I have to subtract the calculated days of that particular column and the result should be in Current PTO YTD.

Likewise, if Leave Type=Sick Leave the I have to compare the field Sick leave in PTO Available, I have to subtract the calculated days of the particular column and the result should be in Current PTO YTD.

I have tried but no result. Can anyone help me in this issue?