Calculation view data preview issue in WEBIDE

[former_member752149]

Hello Team,

While doing data preview of calc view in webide we are getting the below issue while doing data preview on calculation view in webide looking for valuable suggestions.

Thanks in advance.

Error :

Could not open Calculation view::ABC. Error: (dberror) [2048]: column store error: search table error: [6900] Attribute engine failed $message$= unable to create expressioncolumn 'fixed(if("TUV"=0 or isNull("TUV"),0,"Quantity"/"TUV") , 31, 3)': unknown input TUV

Note: TUV is a counter (we tried removing or cond isnull(TUV) but got the same error)

[Abhishek_Hazra]

Hi Kori,
It'll be great if you could share some more information about your design. Are you deriving TUV as a calculated column? From the error message it looks like the field TUV is not known to the expression. Have you named the field correctly, just in case?

Best Regards,
Abhi

[former_member752149]

Hi Abhisek TUV(i mentioned short form it is mentioned correctly in the expression selected using exprsession editor) is a counter i just renamed it in the question

[former_member752149]

Hi Abhisek

if("TUV"=0 or isNull("TUV"),0,"Quantity"/"TUV")

This is the expression we have used TUV is a counter

[Abhishek_Hazra]

With the information provided, I can't find why it should give any error. I hope the data type of TUV is Measure (as you say it is created as a counter), Quantity must also be either decimal or integer & the calculated column you're trying to build is also of type Measure & decimal I presume? If the data types are correctly defined, I don't see any issue with the syntax. You might want to open an incident with SAP in this case.

Regards,
Abhi

[pradeepkds]

Hi Kori,

Have you got any solution? I am getting same issue.

Thanks.

[former_member752149]

Not yet pradeep ,we have raised an incident with sap they are working on it .