What's new in Customer Journeys?

Connect and learn more! ×
IF-THEN-ELSE examples in RTF Word Template Builder? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
edited Aug 25, 2020 11:07PM in HCM Integrations 5 comments


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


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!