Condition with variables

[Anonymous]

Hi all,

I have variables

v1=Sqr(Stdev({<={'aaa'}>}))

v2=Count({<={'aaa'}>})

How can I add condition B='bbb' to this expression?

([1st Time]-after([1st Time]))/SQRT((($(v2)+after($(v2)))/($(v2)*after($(v2))))*($(v1)*(N-1)+after($(v1))*(after($(v2))-1))/($(v2)+after($(v2))-2))

B='bbb' uses for v1 and v2.

Thanks in advance,

[Anonymous]

Who knows how to add SET ANALYSIS for

SQRT((($(v2)+after($(v2)))

I need B='bbb'

Thanks,

[Anonymous]

Set analysis works in aggregation functions, and SQRT is not one of them.  Without trying to understand your logic - may be you can just add the condition to your variables?

v1=Sqr(Stdev({<={'aaa'}, B={'bbb'}>}))

v2=Count({<={'aaa'}, B={'bbb'}>})

[Anonymous]

Hi Michael,

My variable B has 14 different tags(aaa,bbb,ccc,...., fff).

I try to replace B from v1 and v2 to in an expression. Because A is constant for all charts, only B changed in each chart. Other words, I need to add 28 variables, if I add B to your case.

I try to find a trick.

Thanks for reply,