Formula

[francisvandergr]

I have this formula and this one is working

=avg ( {$-1<Relaties.Market = {"ADM*","XX*"}>}Betalingsgedrag.Betalingstermijn)

I wanna have my selection but noy the Relaties.Markets with contains "ADM"or "XX" in it.

Now i want something extra. It is the same as above but only for the field BetalingsgedragBetaaldJaNee={Betaald}

so i wanna combine

=avg ( {$-1<Relaties.Market = {"ADM*","XX*"}>}Betalingsgedrag.Betalingstermijn)

and

=avg ( {$<Betalingsgedrag.BetaaldJaNee = {Betaald}>}Betalingsgedrag.Betalingstermijn)

into 1 formula .

Is this possible ?

[MarcoWedel · Accepted solution]

=avg ( {$<Betalingsgedrag.BetaaldJaNee = {Betaald}>-1<Relaties.Market = {"ADM*","XX*"}>}Betalingsgedrag.Betalingstermijn)

[Anonymous]

You can try

=avg ({$<Betalingsgedrag.BetaaldJaNee = P(Betaald)> - 1<Relaties.Market = {"ADM*","XX*"}>}Betalingsgedrag.Betalingstermijn)