COUNT function in e-Text Template in BI Publisher with HCM extract — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

COUNT function in e-Text Template in BI Publisher with HCM extract

edited Aug 23, 2019 10:14AM in Reporting and Analytics for HCM 6 comments

Summary

COUNT function in e-Text Template in BI Publisher with HCM extract

Content

I used count function in e-text template ,the count function returns no data, any thing i missed?

<LEVEL>

DTCC_IAM_OFF_BOARD_V1

<MAXIMUM LENGTH>

<FORMAT>

<DATA>

<COMMENTS>

<NEW RECORD>

Employment_Rec

 

 

 

Alpha

COUNT(Employment_Rec/Person_Number)

 

 

Aplha

“,”

 

 

Alpha

COUNT(Employment_DG /Employment_Rec/Person_Number)

 

 

Aplha

“,”

 

 

Alpha

COUNT(Employment_DG)

 

 

 

 

<END LEVEL>

DTCC_IAM_OFF_BOARD_V1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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