Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to write a condition where, I want to write if there is a value in dimension then count/include in that count expression.
count({<MyDimension1={'A'}>} MyDimension1)
Note, if MyDimension1 is a key field that's linking two or more tables then use another non-key field to count:
count({<MyDimension1={'A'}>} MyDimension2_NotAKey)
Hi Surender,
Yes, you can create an expression like this:
=Count(Distinct ID)/If(Flag1='Yes',2,1)
Or something more complex like that:
=(Count({<Flag1={"Triple"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID)/3)
+(Count({<Flag1={"Si"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID)/2)
+(Count({<Flag1={"No"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID))
-JFlorian
Thank you, it worked.