Standard Deviation

[satishkurra]

Hi All

I need to calculate the revenue which falls between (StdDev * -0.5 + Mean) and (StdDev * 0.5 + Mean)

I'm using below expression but no luck.

Please help

=Sum({<ID =

{"=

Sum([Revenue]) >=

(Stdev(TOTAL Aggr(Sum([Revenue]), ID)) * -0.5)

+

Avg(TOTAL Aggr(Sum([Revenue]), ID))

and

Sum([Revenue]) <=

(Stdev(TOTAL Aggr(Sum([Revenue]), ID)) * 0.5)

+

Avg(TOTAL Aggr(Sum([Revenue]), ID))

"},

FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=

>}[Revenue])

[satishkurra]

Anyone please...

[shiveshsingh]

Can you share some sample data, excel??

[satishkurra]

Attached is the sample data and app.

It has 2 expressions

1. Revenue/Hours

2. Hours

I'm trying to display in scatter plot using dimension ID

Also the current logic is to display ID's between 5 and 95 percentile. Hence i used FRACTILE function.

However when i select random data, attached is the image and highlighted in RED, it is saying NO DATA TO DISPLAY.

Now i'm trying to get to the state of achieving between (StdDev * -0.5 + Mean) and (StdDev * 0.5 + Mean)

Thanks

Satish