How can I add a column for % Holiday Balance remaining
I'm looking to see if anyone has the correct formula for me to use, or has already added in the column for '% Balance Remaining' for the annual holiday accruals.
I have created a report for managers to run to identify a number of Holiday Balance values, i.e. Annual Accrual, Adjustments, Carryover, Absence booked or Taken, and remaining Accrual balance. There is now a requirement to add the % of Balance remaining on this report, and whilst I have all the data fields I need, I cannot get the % data to be correct.
Many thanks in advance for any help or suggestions you can offer.