Standard Deviation Formula

[jerryr125]

Hi - 

This seems pretty straight forward but it does not seem to work.

I have a numeric field and would like to calculate the standard deviation in a KPI.

Not working:

Field Name : AmountSpent

=StDev([AmountSpent])

Thoughts ? Jerryr

[jerryr125]

HI - 

yes the field is :

[On average, how much do you normally spend at a movie theater on snacks?]

Also the data is fictitious test data - 20 records.

[lorenzoconforti · Accepted solution]

That one in your chart is not a KPI object, it's a filter pane. 

You just need to use the right object 🙂

[jerryr125]

silly error on my part !!

Thank you so much ! - Jerry