Hi,

I am creating one analysis on the Workforce Goals - Goal Status Overview Real Time subject area in OTBI.

Want to create a pie chart that shows the submitted and not submitted goals count. Below is the calculation am using:

case when ("Workforce Goals - Goal Status Overview Real Time"."- Goal Management Process"."Count of All Performance Goals"-"Workforce Goals - Goal Status Overview Real Time"."- Goal Management Process"."Count of Canceled Goals") >= 1 Then 'Submitted' Else 'Not Submitted' END

and the error am getting is:

Any help here please.

Thanks