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

Visit Redwood Community
OTBI report to sum element Medical ER rate for calendar year where payroll isn't processed in Oracle — 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

OTBI report to sum element Medical ER rate for calendar year where payroll isn't processed in Oracle

Received Response
13
Views
5
Comments

Summary:

Looking for OTBI report to sum element Medical ER rate for calendar year per employee where payroll isn't processed within Oracle for W2. Or if someone has a data model example I could use that would be great.

Content (required):

I've used the below and the results $ are higher than expected. Using Time folder and picking calendar year. Element Entry is just called Medical ER.

SUM((Case when "Input Value"."Input Unit of Measure Code" = 'M' then 

CAST ("Element Entry Value"."Displayed Input Value" as Numeric) when "Input Value"."Input Unit of Measure Code" = 'I' then 

CAST ("Element Entry Value"."Displayed Input Value" as Numeric) when "Input Value"."Input Unit of Measure Code" = 'N' then 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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