Skip to Content
avatar image
Former Member

SAP Business Objects Webi Cross Tab report

Hi

I am facing an issue to get the column to the cross tab report, then the column is empty.

i have created an variable with if condition and pulled the same in the report .

like

= If [Difference] < 1 Then "A" Else If ([Difference] >= 1 And [Difference] <= 3) Then "B" Else If ([Difference] >= 4 And [Difference] <= 6) Then "C" Else "D"

Now while using this condition . i am getting only two columns in the report A&B , since there is data only for A& B . But i want columns C and D in the reports and its value as 0.

Please tell me how can i get the columns when there is no data .

Thanks

Arun K

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 13, 2016 at 09:54 AM

    Hello Arun,

    In this case you can create 4 static columns named A,B,C, D and then for each column you can write condition.

    There will be 4 Condition for 1 for each column with Else part as "0"

    Regards,

    Sushil Padhye

    Add comment
    10|10000 characters needed characters exceeded