Conditional Formula - Syntax Error

[Former Member]

Hello All,

I have written the following formula in Bex in BI 7

(f04=1)((ebit<0)((abs(ebit)-(dep))-1)+(NOT(ebit<0))(ebit(dep)))(not(f04=1))*(ebit-(dep))

Though i feel that the formula is correct. The system is giving a syntax error. Request you to please help...

Regards

Nilesh

[Former Member · Accepted solution]

Hi Nilesh,

Cheack if it works.

( f04 == 1) * ( ( ebit < 0 ) * ( ( abs ( ebit ) - ( dep ) ) * -1 ) + ( ( ebit >= 0 ) ) * ( ebit + ( dep ) ) ) + ( ( f04 <> 1 ) ) * ( ebit - ( dep ) )

Regards.

[Former Member · Accepted solution]

Dear Dash,

It worked. Thanks for your help. Points awarded.

[Former Member]

Hi Nilesh,

One bracket missing or extra, see Bold one below:

(f04=1)((ebit<0)((abs(ebit)-(dep))-1)+(NOT(ebit<0))(ebit(dep))<b>)</b>(not(f04=1))*(ebit-(dep))

Hope it Helps

Srini