Skip to Content
avatar image
Former Member

Case Statement Issue in Webi Report

Hello Experts,

I need to assign different Strings for different variable results under one field(Control) using Case Statement:

I have result fields as: V_Year, V_Month and V_Day

the above fields will have 1,0 values as result :

So I planned to use

Case  When V_Year =1 Then "Year"  When V_Month =1 Then "Month"  When V_Day = 1 Then "Day" Else "Total" End

As we have no Case statement available in Webi I tried below Neseted if Elseif and If conditions

The result is

If  V_Year =1 Then "Year" elseif  V_Month =1 Then "Month" elseif  V_Day = 1 Then "Day" Else "Total"
If ( V_Year =1 ; "Year"; if ( V_Month =1; "Month";if ( V_Day = 1;"Day" ; "Total")))

Please advise

Regards,

Raja

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 01, 2017 at 02:51 PM

    Hi Raja, try using "SAP BusinessObjects - Web Intelligence (WebI)" for your question tag, might have better luck getting an answer. "SAP Web Analytics" is something different.

    Add comment
    10|10000 characters needed characters exceeded