Hi,

I tried this query but it seems that it's not working. It's throwing an error (Formula syntax is invalid). I'm using this query to determine if employees have submitted their reported hours or not. Do you also have documentation regarding OTBI joins?

select t1.t
,ifnull(t2.c,upper('wo')) as m
from

(
select all "Time"."Calendar Date" as t
from "Workforce Management - Reported Time Cards Real Time"

)t1

left outer join

(
select all "Time"."Calendar Date" as t
,"Reported Time Cards"."Reported Hours" as n
,cast("Reported Time Cards"."Reported Hours" as character) as c

from "Workforce Management - Reported Time Cards Real Time"
)t2

on(
t1.t = t2.t
)

Thank you in advance