How to get total total employees, total net pay?
I have custom record. On that they have stored employee, net pay/ CP Employee/CP Employer/ Income Tax Deduction. Now I want to get total amount for net pay, CP Employee, CP Employer, Income Tax Deduction Separately and show it on suitelet.
I tried this by creating a saved search:
Criteria: Pay code is any of net pay ,CP Employee,CP Employer, Income Tax Deduction.
Result: Amount, Pay Code
And exported search to suitelet script. In script I am getting result. Getting total search result count. How to get total amount for net pay, CP Employee, CP Employer, Income Tax Deduction Separately?
Please Help!