Set Analysis using Variable

[vanderson009]

Hi guys,

Please have look at set analysis that i am using

=Sum({<OrderWeek = {'$(vMaxWeek)-1'}>}Amount)

I want currentweek - 1 amount, but it won't work.

vMaxWeek is variable as Max(OrderWeek)

- Thanks and Regards,

Villyee

[#2]

=Sum({<OrderWeek={$(vMaxWeek)-1}>} Amount)

Just remove the quotes.

[jonathandienst]

Hi

Assuming OrderWeek is a simple numerical field:

     =Sum({<OrderWeek={$(=vMaxWeek-1)}>} Amount)

Should do the trick, but try using the function directly like this:

     =Sum({<OrderWeek={$(=Max(OrderWeek)-1)}>} Amount)

HTH

Jonathan

[#4]

try this

=Sum({<OrderWeek = {'$(=(vMaxWeek-1))'}>}Amount)

regards,

MT

[VishalWaghole · Accepted solution]

Hi Villyee,

Try

=Sum({<OrderWeek = {'$(=(vMaxWeek-1))'}>}Amount)

or

=Sum({<OrderWeek={$(=Max(OrderWeek)-1)}>} Amount)

-- Regards,

Vishal

[vipin_mishra479]

HI villye,

create a variable of this (vMaxWeek)-1

like vPweek = (vMaxWeek)-1

and then use

Sum({<OrderWeek = {'$(vPweek )'}>}Amount)

[vanderson009]

Thanks vishal, its working.............