Offset dates in set analysis

[#1]

Hi all,

I want to get the standard deviation of a set of values. There is more than year's data in the file, but I only want to consider the values of the last 150 days in the expression. I currently have:

=Stdev({$<[process date]={">=$(Date(today()-150),'DD-MM-YYYY')"}>}  [Quantity produced] )

(The format of process date is 'DD-MM-YYYY')

Can someone please point me in the right direction?

Kind regards,

Florian

[sunny_talwar · Accepted solution]

May be try this (Edits in Red)

=Stdev({$<[process date]={">=$(=Date(Today()-150, 'DD-MM-YYYY'))"}>}  [Quantity produced])

[Gabriel]

Hi,

As stated by sunindia above you need the equal (=) sign before the Date. You are using a function there is it has to evaluate and to achieve that equal sign is needed.

=Stdev({$<[process date]={">=$(=Date(today()-150),'DD-MM-YYYY')"}>}  [Quantity produced] )

[sunny_talwar]

I think there is a misplaced parentheses in there too...

=Stdev({$<[process date]={">=$(=Date(today()-150),'DD-MM-YYYY')"}>}  [Quantity produced])

vs.

=Stdev({$<[process date]={">=$(=Date(today()-150,'DD-MM-YYYY'))"}>}  [Quantity produced] )

[#5]

Thanks a lot, this works perfectly. Gabriel thanks for the explanation about the equals sign, I was unaware of this.

[sunny_talwar]

Awesome, we are glad to help