Skip to Content
avatar image
Former Member

Error in calculated column if condition in analytical view

Hi,

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.

Thanks
Sri

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?

    Regards,

    Rashmi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Guyz,

      Solved. Following is the syntax

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

      Regards

      Sri    

      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

    Hi,

    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,

    Mahesh

    Add comment
    10|10000 characters needed characters exceeded