Skip to Content
avatar image
Former Member

Error in calculated column if condition in analytical view


I am having issue in calculating with condition in HANA. I am creating  calculated column in which my condition is

if ("OTYPE = "ZMTS", Netvalue * 10, Netvalue * 5 )

For testing purpose I even tried if ("OTYPE = "ZMTS",50,75) but still error.

my calculated column data type is "Decimal" and column type is measure.

When i try this with key figure like if(Netvalue >1000,10,5) this works fine.

Is there any different way when we are dealing with non key figures in condition.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 27, 2015 at 07:28 AM

    Hi Sri,

    I couldn't see "OTYPE" , "ZMTS" columns in VBRP table. On what type of columns you have created calculated column?

    Also, can you click on 'Validate' button inside calculated column wizard to check syntax of the expression is correct or not?



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Guyz,

      Solved. Following is the syntax

      (("PSTYV" = 'ZMTS'),"NETWR" * 5,"NETWR")  



      PS: Hi Venkat....I got the solution before you posted. Thanks for your help. Assigned points. :-)

      Message was edited by: Sri BW

      NETWR2.PNG (13.1 kB)
  • avatar image
    Former Member
    May 27, 2015 at 06:34 AM


    In Analytic View you should use all the measures from the Single Fact table. Even this applicable to Calculated columns.

    To utilize both measures from two fact tables go for Calculation View.

    Thanks and Regards,


    Add comment
    10|10000 characters needed characters exceeded