on 05-27-2015 7:31 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rashmi,
Thanks for reply. I tried with the condition that you have mentioned. Its working but not as expected.
For ZMTS , column is not calculating NETWR * 5, Its just displaying value of NETWR. For others its just displaying Question mark"?".
I also tried
if(("PSTYV" = string("ZMTS")),int("NETWR"*5),Int("NETWR")) but not luck.
Thanks
Srikanth
Hi Srikanth,
Here ZMTS is a value, not column. Try one of the below syntax it should work. (We should not use double quotes for values, it's only for columns).
if("PSTYV" = 'ZMTS',"NETWR"*5,"NETWR")
If the above one gives any syntax errors, try beow.
if(string("PSTYV") = 'ZMTS',"NETWR"*5,"NETWR")
Regards,
Venkat N.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.