Skip to Content

How would I force in the value for a custom variable?

Nov 22, 2017 at 01:49 PM


avatar image
Former Member


Will try to not be too vague. Apologies if I am

Using SAP Business Objects 4.1 pack 5

Have created a banding variable, but if the are no attributable values associated with any specific banding it is not getting shown in the list.

For example, do have the following code

=If([Invoice Count 2017]<=0;"<0";If([Invoice Count 2017]=1;"1";If([Invoice Count 2017]=2;"2";If([Invoice Count 2017]=3;"3";If([Invoice Count 2017]=4;"4";If([Invoice Count 2017]>=5 And [Invoice Count 2017]<=10;"5-10";If([Invoice Count 2017]>=11 ;"11>";""))))))) ForEach ([Joinery 2017].[Customer])

The problem is that if there are no customers falling under "11>" it is not getting shown in the list


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

0 Answers