IF-THEN-ELSE examples in RTF Word Template Builder?

Summary

IF-THEN-ELSE examples in RTF Word Template Builder?

Content

Hi Forum:

After my Detail row on BI report, i need to count up each type of (2) columns of Detail.

Column A - Employee Status:  'ACTIVE', 'INACTIVE'

Column B - Assignment Status 'LOA Payroll Eligible", "LOA - No Payroll"

MY DETAIL ROW at top is:

Person   Name Company     Employee_Status      Assignment_Status

=====================================================

1  John Doe     ABC             ACTIVE                    'Active - Payroll Eligible'

2  Jane Smith XYZ              INACTIVE                 'LOA - No Payroll '

 

Totals for Active Employees: 999999.99

Totals for Inactive Emps: 9999999.99

Totals for LOA Emps: 9999999.99

Totals for Terminated Emps: 9999999.99

 

Grand Total Employee Records:  999999.99

 

I'm getting XML from globalReportsDataModel when my Extract runs