Demantra Solutions - EBS (MOSC)

MOSC Banner

What's wrong with this Server expression, it gives error "Invalid Expression". Just want to check sy

Server Expression:

SUM( CASE WHEN branch_data.sales_date >= get_max_date()  THEN NULL ELSE  ( CASE WHEN(  (1-(CASE WHEN BRANCH_DATA.SALESPLUS= 0 or BRANCH_DATA.SALESPLUS = NULL  or BRANCH_DATA.utc_final_fc_lag1 = 0 THEN 1 ELSE ABS(BRANCH_DATA.utc_final_fc_lag1 - BRANCH_DATA.SALESPLUS)/BRANCH_DATA.SALESPLUS ) END)<0 THEN 0

ELSE

(1-(CASE WHEN BRANCH_DATA.SALESPLUS= 0 or BRANCH_DATA.SALESPLUS = NULL  or BRANCH_DATA.utc_final_fc_lag1 = 0 THEN 1 ELSE ABS(BRANCH_DATA.utc_final_fc_lag1 - BRANCH_DATA.SALESPLUS)/BRANCH_DATA.SALESPLUS )END)) ) END )

NOTE:

BRANCH_DATA.SALESPLUS   refers to Adjusted History Series

BRANCH_DATA.utc_final_fc_lag1 refers to final forecast lag 1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center