Skip to Content

Case Statement Issue in Webi Report

Jan 12, 2017 at 06:14 PM


avatar image
Former Member

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



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lee Clemmer
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.

10 |10000 characters needed characters left characters exceeded