Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
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
17
Views
5
Comments
edited Aug 25, 2020 11:07PM in HCM Integrations 5 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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