Stdev, ignore dates with zero values

[#1]

Hi,

I need to calculate the StDev of AMOUNT however when trying stdev(AMOUNT) I receive an incorrect value since it is also accounting for dates with zero values. I want it to calculate for dates with data only in my date range selection.

Any ideas?

Regards,

Olle

[#2]

anyone?

[swuehl · Accepted solution]

Maybe like

stdev({<AMOUNT= {"*"} >} AMOUNT)

or

stdev({<AMOUNT= {">0"} >} AMOUNT)