IFThen Formula Returns Error "Extra Parenthesis" In Financial Reporting Report From Version 11.1.2.1 (Doc ID 1401550.1)

Last updated on DECEMBER 24, 2013

Applies to:

Hyperion BI+ - Version 11.1.2.1.000 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Dec-2013***

Symptoms

In Financial Reporting Version 11.1.1.2 the following formula validates without error:
IFTHEN (([241]+[242])<0,Sum([241,[242]),0)

In Financial Reporting Version 11.1.2.1 the same formula does not validate and asks you to remove the extra parenthesis:
IFTHEN (([241]+[242])<0,Sum([241,[242]),0)


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms