Problem with 2 Data Source Providers

building reports webintelligence
1

HI,

I am trying to Create a Report with 2 Data Source Providers where I need to display those AFF Accounts whose AFF Modality is not Present in the same Account’s GPH modality given in the second block as given blow:

I tried to apply the formula:

=[AFF Account]Where([AFF Modality]<>[L6 GPH Modality])
and
=IF([AFF Modality]<>[L6 GPH Modality];[AFF Account])

It displays as below:

The Problem is It is not Displaying the AFF Modality and Amount based on Each Account rather the Amounts are being summed up based on group by AFF Modality even though there is no Group Applied in any columns…
Due to this the AFF Account is not getting displayed…

Please Help…
Thank In Advance

enjoyy2j :india: (BOB member since 2008-04-17)

2

links are leading to a blank page…

rohit12 :india: (BOB member since 2008-11-08)

3

Following are the links:

Link 1: http://img529.imageshack.us/img529/2218/ss1igu.jpg

Link2: http://img17.imageshack.us/img17/5024/ss2zxj.jpg

Have also attached the 2 scrrens
ss2.JPG
ss1.JPG

enjoyy2j :india: (BOB member since 2008-04-17)

4

First merge your two dimensions…

AFF Modality and GPH Modality

then try applying the formula posted above…

rohit12 :india: (BOB member since 2008-11-08)

5

HI I did that too… but it doesnt change anything…

and even if I merge Its just gonna return those Modalities which are present in both
ss3.JPG

enjoyy2j :india: (BOB member since 2008-04-17)