Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Villyee,
Try
=Sum({<OrderWeek = {'$(=(vMaxWeek-1))'}>}Amount)
or
=Sum({<OrderWeek={$(=Max(OrderWeek)-1)}>} Amount)
-- Regards,
Vishal
=Sum({<OrderWeek={$(vMaxWeek)-1}>} Amount)
Just remove the quotes.
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
try this
=Sum({<OrderWeek = {'$(=(vMaxWeek-1))'}>}Amount)
regards,
MT
Hi Villyee,
Try
=Sum({<OrderWeek = {'$(=(vMaxWeek-1))'}>}Amount)
or
=Sum({<OrderWeek={$(=Max(OrderWeek)-1)}>} Amount)
-- Regards,
Vishal
HI villye,
create a variable of this (vMaxWeek)-1
like vPweek = (vMaxWeek)-1
and then use
Sum({<OrderWeek = {'$(vPweek )'}>}Amount)
Thanks vishal, its working.............