cancel
Showing results for 
Search instead for 
Did you mean: 

Query on Calculated Column

Former Member
0 Kudos

Hi Frzz,

I have created one calculated column. In which i have to check the condition as

IF ( "PTYPE" = 'OR', "PTYPE",'')

But when am activating the view its hanging up. The value 'OR' is key word inHANA. Is that is the reason??

Best Regards,

Krishna.

Accepted Solutions (1)

Accepted Solutions (1)

former_member182114
Active Contributor
0 Kudos

Hi Krishna,

You posted your assumption but not the error, please add more details here.

OR is reserved but 'OR' is a string, no problem.

Regards, Fernando Da Rós

Former Member
0 Kudos

Hi Fernando,

Thank you.

But if you see the screen, OR is highlgihted in Calculated Column Editor, which means it is considering OR as key word??

former_member182114
Active Contributor
0 Kudos

Hi Krishna,

Again you posted the assumption without the error. See on your screen shoot that OR is with a different colour but IF this leads me to a quick answer.

What about the error you are facing?

What about which datatype PTYPE is?

Regards, Fernando Da Rós

Former Member
0 Kudos

Hi Fernando,

Thanks for your quick response.

Actually there was some issue with the Server. Thats why its hanged. Not due to the value 'OR'.

Thanks a lot.

Best Regards,

Krishna.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

Please try using string functions to compare. Do not use '=' directly if possible.