Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
i have the following Problem.
In this Picture, the following calculation gives these results :
=COUNT ( { < S.Termin={"0"},vkselbst ={'VKyes'} > } DISTINCT KNneu) = 1
=COUNT ( {< S.Termin={"0"}, vkselbst ={'VKno'},spselbst={'SPyes'} > } DISTINCT KNneu) = 0
Which is correct.
Now if i select more Months:
I get for the same Formulas :
=COUNT ( { < S.Termin={"0"},vkselbst ={'VKyes'} > } DISTINCT KNneu) = 1
=COUNT ( {< S.Termin={"0"}, vkselbst ={'VKno'},spselbst={'SPyes'} > } DISTINCT KNneu) = 1.
The Second Formula is wrong.
What i want is, if "VKyes" appears in the list and spselbst is "SPyes" , then return 0. Only if the hold list contains "VKno" and anywere "SPyes" then return 1.
This is a imported Excel List. No Calculations in the presented Table.
May be this
=Count({<
S.Termin={"0"},
KNneu = e({<vkselbst = {'VKyes'}>},
spselbst = {'SPyes'}
>} DISTINCT KNneu)
May be this
=Count({<
S.Termin={"0"},
KNneu = e({<vkselbst = {'VKyes'}>},
spselbst = {'SPyes'}
>} DISTINCT KNneu)
I have to check it, but seems to be correct. Thank you very much Sir !