5 Replies Latest reply: Feb 19, 2015 6:48 AM by Rekha Harish

# How to maximum/minimum value from the current selection date to previous 52 weeks

Hi,

when I select a date/month column, I need a text box which displays the maximum price from the selected date until previous 52 weeks(1 year) .

Similarly I need the minimum price from the selected date to last 52 weeks .

How do I achieve this?

• ###### Re: How to maximum/minimum value from the current selection date to previous 52 weeks

Hi Rekha,

And it will be good if you can share sample data.

Thanks,

Laxmi

• ###### Re: How to maximum/minimum value from the current selection date to previous 52 weeks

Hola,

let vEnd=today();

let vStart=today()-365;

expression 1 is max(Date={">=\$(=Date(vStart))<=\$(=Date(vEnd))"}>}price)

expression 2 is min(same as above)

HTH

• ###### Re: How to maximum/minimum value from the current selection date to previous 52 weeks

Hi Ravi,

am getting an error for the set analysis expression.could you help me out

• ###### Re: How to maximum/minimum value from the current selection date to previous 52 weeks

use the '\$' symbol before the variable..

max(Date={">=\$(=Date(\$(vStart)))<=\$(=Date(\$(vEnd)))"}>}price)