1 Reply Latest reply: Oct 15, 2018 4:22 AM by Stefan Wühl RSS

    Flag creation help  in straight table

    P Kumar

      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.

       

      Mismatch.png

       

      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.