OTBI report to sum element Medical ER rate for calendar year where payroll isn't processed in Oracle
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
Tagged:
0