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