Flag creation help in straight table

[pawwy1415]

Hi Experts,

Can any one please help me to remove the first row from the below table.

When last flag Mismatch= null then by using add on i can remove the complete row.

But i am not getting how to change to null.

Requirement:

I have to show only Match records from the Flag1 and flag2 will show both match and mismatch based on the data. but flag1 has to show only match records.

Please find the below expressions which i have used in each column.

Here i am getting extra row only after adding flag2

Here ID is the calculated dimension  which is calculated like below

ID:

=IF(ISNULL(Aggr(if(Match([Source System],'Sytem changer'),[External Identifier],

if(Match([Source System],'Internal changer'),[Internal dentifier])),[Trade ID])),'Not Available',

Aggr(if(Match([Source System],'Sytem changer'),[External Identifier,

if(Match([Source System],'Internal changer'),[Internal Identifier])),[Trade ID]))

Column1:

if (fabs(Round(Sum({<Status Type]={'Yes'}>}[GBP]),0.01)) =fabs(Round(Sum({<[Status Type]={'No'}>}[GBP]),0.01)),

fabs(Round(Sum({<[Status Type]={'Yes'}>}[GBP]),0.01)))

Column2:

if (fabs(Round(Sum({<Status Type]={'Yes'}>}[GBP]),0.01)) =fabs(Round(Sum({<[Status Type]={'No'}>}[GBP]),0.01)),

fabs(Round(Sum({<[Status Type]={'No'}>}[GBP]),0.01)))

Flag1:

if(Column1 =Column2,'Match')

Column6:

if (fabs(Round(Sum({<Status Type]={'Yes'}>}[GBP]),0.01)) =fabs(Round(Sum({<[Status Type]={'No'}>}[GBP]),0.01)),

fabs(Round(Sum({<[Status Type]={'Yes'}>}Tradeid),0.01)))

Column7:

if (fabs(Round(Sum({<Status Type]={'Yes'}>}[GBP]),0.01)) =fabs(Round(Sum({<[Status Type]={'No'}>}[GBP]),0.01)),

fabs(Round(Sum({<[Status Type]={'No'}>}Tradeid),0.01)))

Flag2:

=if(Column(4)=Column(5),'Match','Mismatch')

Thanks in advance.

[swuehl · Accepted solution]

Maybe just add the flag1 condition in addition:

=if(Column1 = Column2,If(Column(4)=Column(5),'Match','Mismatch'))