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

[#1]

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

[jagan]

Hi,

Try using this

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,0)

Hope this helps you

Regards,

Jagan.