AVG,STDEV from expression

[hariprasadqv]

Hi All,

I am stuck in calculating Avg and Stedev from a table of values in which the values are generated from an expression. PSB for clarity

Here I am calculating Target from the below expression

num(count({$<TABLE_NAME = {'TARGET'}, VARIANCE = {'>0'}>} CONTACT_WID)/count({$<TABLE_NAME = {'TARGET'}>} CONTACT_WID) * 100,'##.##')

*I know that we can cliculate avg and Stdev in a Stright table through TOTAL option.

But I want to caliculate AVG and STDEV for the above table of values and I have to store them in a variable.

your help will be highly appreciated

Thanks in advance.

[hariprasadqv · Accepted solution]

I got the solution.

Thanks to viewers

=AVG(aggr(count({$<TABLE_NAME = {'TARGET'}, VARIANCE = {'>0'}>} CONTACT_WID)/count({$<TABLE_NAME = {'TARGET'}>} CONTACT_WID) * 100,COUNTRY))

=STDEV(aggr(count({$<TABLE_NAME = {'TARGET'}, VARIANCE = {'>0'}>} CONTACT_WID)/count({$<TABLE_NAME = {'TARGET'}>} CONTACT_WID) * 100,COUNTRY))