Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I need to have the distinct count of three different field (let's say field A, B and C) in one expression.
I know the distinct count of two fields (A and B) in one expression is the following:
=Count(Distinct A) + Count({<B -= p(A) >}Distinct B)
I tried the following for the three field counter:
Count(Distinct A) + count({<B-= p(A)>}distinct B) + count({<C-= p(A)>}distinct C)
Unfortunately, it doesn't work.
Could you help me out? Thanks in advance!
May be this
=Count(DISTINCT A) + Count({<B -= p(A) >}DISTINCT B) + Count({<C-= p(A)+p(B)>} DISTINCT C)
May be this
=Count(DISTINCT A) + Count({<B -= p(A) >}DISTINCT B) + Count({<C-= p(A)+p(B)>} DISTINCT C)
Roland, did Sunny's post help you get what you needed? If so, please be sure to return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and to let other Community Members know this worked for you. If you still need further help, please leave an update.
Regards,
Brett