Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I m using below exp
vMonth and cMonth
Only({<[Month]={$(vMonth)}>}Visits)
Only({<[Month}={$(cMonth)}>}Visits)
to calulate visits for two month selected by user from input box.
now i want to do minus 1 from vMonth and cMonth in this exp i have used many
but not getting current result.
can any baody give right exp how to modify above exp so that it will select minus one month selected by user in input box
when user select june ,i want select may by using above two exp.
your Month value are Jan, Feb....? or 1,2,3?
try
month(makedate(2012,$(vMonth)-1,1))
may month is jan ,feb..........
You could try:
Only({<[Month]={"=$(AddMonths(vMonth),-1)"}>}Visits)
Hope this helps,
Jason