How to make summary Column.How to calculate Sum of a column.
Hi I have a af:table that displays information about Employee vacation. I want to sum the value of the column "ActualNumberOfDays". Here is the table. I will Explain how I calculated the total of the "Acutal days" column. 1- I Created a readonly view based on Query SELECT v_emv.ID emv_id, v_emp.EMP_ID emp_id, v_emp.EMP_NAME_AR ar_name_full, v_emp.EMP_NUM, v_vat.NAME_AR, v_emv.START_DATE, v_emv.END_DATE, v_emv.NUMBER_OF_DAYS, v_set.ACTUAL_END_DATE set_end_date, v_emv.HOLIDAYS, v_emv.VACATION_STATUS, v_set.ACTUAL_NUMBER_OF_DAYS - NVL(v_set.ACTUAL_HOLIDAYS, 0) - NVL(v_set.MISSION_DAYS, 0) actual_number_of_days FROM HRS_V_EMP_BASIC_INFO v_emp, HRS_V_EMP_VACATIONS v_emv, HRS_V_VACATION_TYPES v_vat, HRS_V_EMP_VACATION_SETTLEMENTS v_set WHERE v_emv.EMP_ID = v_emp.EMP_ID AND v_set.EMV_ID(+) = v_emv.ID AND v_emv.VAT_ID = v_vat.ID 2- in a managed bean , Add attribute private int totalVacationDays; an