Hello,
i have a interesting display of value, even in my opinion it should be not showed at all:
I'm using following aggregation to switch a dynamic table with a variable Zero and One
=aggr(if($(vTest)='0',count({$<Status2={'K'}>}Serialnumbers),count({$<Status2={'V'}>}Serialnumbers)),Date)
Its a dimension in a straight table:
Its aggregated to the date.autocalendar.date. As you can see my switch is set to 'zero' which is my variable vTest='0'.
So the count should only referring to the serialnumbers with a status2='K'. But why I can also see a number count for these who have Status V, just because they share the same date?
But when I'm adding sum function it really counts me ONLY the ones which should be filtered correctly:
=sum(aggr(if($(vTest)='0',count({$<Status2={'K'}>}Serialnumbers),count({$<Status2={'V'}>}Serialnumbers)),Date))
Is it intended to aggregate the count like this?
Thanks in advance.