Assistance using Isnull

building reports webintelligence
1

I am concatenating 2 objects Object1 and Object2 .with formula =Object1+" -" +Object2 as a variable called “concatenation”.

Now I have to create 2nd variable as
Most of time Object1 can be either 0 or NULL.In that case I have to display Object2 value with “-0”
See the scenario below
Object 1 object 2 Concatenation
12 786 12-786
0 54 54-0
123 123-0

I am trying to write a formula
=If(IsNull([Object1])) Then ([Object2] +’-0’) Else [concatenation].
But it displays date instead of -0 for the blank Object1 but 0 is displayed correct.HOw to make it work as same even when it is blank.
Both Object1 and Object 2 are dimension Objects

Advance Thanks In help

Minne (BOB member since 2004-12-10)

2

Need help on this…Is this doable…Just let me know please

Thanks
Pavani.

Minne (BOB member since 2004-12-10)

3

Hi shouldn’t your formula be
=If(IsNull([Object1])) Then “0”+[Object2] Else [concatenation], instead ?

rgoulart :brazil: (BOB member since 2011-08-21)

4

Sounds pretty easy, if there was more info as it is a little confusing… I guess there is no intelligence about which number comes first, so I won’t question that. I think based on what I believe you said, try the following:

=If IsNull([Object1]) Or [Object1]=0 Then [Object2] +"- 0" Else [concatenation]

or as a combined variable:

=If IsNull([Object1]) Or [Object1]=0 Then [Object2] +" - 0" Else [Object1]+" - "+[Object2]

datawizard (BOB member since 2015-01-20)