1 Reply Latest reply: Dec 6, 2011 7:46 AM by jagan mohan rao appala RSS

    Suppres lines in a table when they content only NULL()

      I have a tablle, which shall show every day as a line where changes on some named issues (eg Status, KSt) happened - the changes are marked cyan, to show them. The problem is, that lines, which contents only NULL() values shall nat be shown, but they are! I think all settings are correct.
      To show the changes i use the ABOVE function to compare, if there are changes. Instead of ' ' i also tried to use NULL() or nothing - allways the same result.
      if(PNR <> Above(PNR)
      or (NNAME&' '&VNAME) <> Above((NNAME&' '&VNAME))
      or KST <> Above(KST)
      or AKT <> Above(AKT)
      or Betreuer <> Above(Betreuer)
      or AUSH <> Above(AUSH), 1,'')
      I also tried to use a calculated dimension - and then suppres NULL (which is allways selected) the same bad result.
      =Aggr(
      if(PNR <> Above(PNR)
      or (NNAME&' '&VNAME) <> Above((NNAME&' '&VNAME))
      or KST <> Above(KST)
      or AKT <> Above(AKT)
      or Betreuer <> Above(Betreuer)
      or AUSH <> Above(AUSH),
      Datum),
      Datum)
      Has any one an idea, how to suppres the lines, when it contents only NULL() values? I added a demo version as a zip file including data. It is not possible to do this in scripting -> Thanks for any help