Skip to Content
avatar image
Former Member

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

Hi,

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

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers