Skip to Content
0
Apr 23, 2014 at 09:10 AM

Error in the Analytic View

1067 Views

Hi,

Created a input parameter to display the currency code as EUR(Europe), USD(US Dollar), INR(Indian Rupee).

Have created a Calculated Column and invoked the Input paramter within the Calculated Column. When the User selects the respective currency, must display only the valid data. But in this case, I am unable to preview the data and it results with the error.

Formula for the Calculated Column is -

(('$$CURRENCY$$'='EUR'),"SALES REVENUE" *1.4,"SALES REVENUE")

Error executing the query

Error: SAP DBTech JDBC: [266]: inconsistent datatype: [6970] exception 6970:
AttributeEngine/InternalTable.cpp:6607
Evaluator: type error in expression evaluator; $function$=createExpressionColumnEx; $message$=unable to create expressioncolumn 'fixed(if(('EUR'='EUR'),"SALES REVENUE" *1.4,"SALES REVENUE"), 8, 2)': Evaluator: type error in expression evaluator;fixed8_8.2 fixed_8(if(int eq(string 'EUR', string 'EUR'), [here]times(string "SALES REVENUE", decfloat '1.4'), string "SALES REVENUE"))(6970); $message$=unable to create expressioncolumn 'fixed(if(('EUR'='EUR'),"SALES REVENUE" *1.4,"SALES REVENUE"), 8, 2)': Evaluator: type error in expression evaluator;fixed8_8.2 fixed_8(if(int eq(string 'EUR', string 'EUR'), [here]times(string "SALES REVENUE", decfloat '1.4'), string "SALES REVENUE"))(6970)

Can any one let me know the process to resolve this issue?

Thanks and regards

Sanjay