count if x = O or Y= O

[bbmmouha]

hello

i have a little problem i have three table

table tiers ; cod_tiers , age , nom , prenom

table presence ; cod_tiers , present ( yes , no , null )

table vote ; cod tiers , vote ( yes , no , null )

what i want is count cod_tiers if present = yes or vote = yes

i tried this but it is incorrect =count({<VOTE={'O'},PRESENCE={'O'}>} COD_TIERS) this give me present = yes and (not or ) vote = yes

thank you for your answer in advance

[ElizaF]

Hello,

Try the expression:

Count({$<COD_TIERS=P({1<PRESENT={'YES'}>}COD_TIERS),

                COD_TIERS=P({1<VOTE={'YES'}>}COD_TIERS)

      >}COD_TIERS)

Also, for the performance of the app, I recommend a single FACT table with the necessary data. See the attached file.

[vinieme12 · Accepted solution]

Count({<PRESENT={'YES'}>+<VOTE={'YES'}>} DISTINCT COD_TIERS)

For other similar problems, see my reply on this post

Re: Nested Set Analysis - Customer bought in both time periods

[bbmmouha]

thank you

i learned something new 

[bbmmouha]

thank you

[vinieme12]

Glad to help

Cheers

V