Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a very simple set analysis question.
In the ordr table we have a filed which stores the year value of the order ex. 2010, 2011, 2012, 2013 and so forth.
I am trying to get my set exprerssion dynamic and running into the following ptoblem
Original expression
sum({$<ORD_YR ={'2013'} >} AMT) --> Works great
New one
sum({$<ORD_YR ={"= $(=num(year(Today(0))))"} >} AMT) ---> Doesn't consider the set expression results are same as sum(AMT)
An alternate that works
sum({$<ORD_YR ={">= $(=num(year(Today(0))))"} >} AMT) --> please note the >= comparison
So how do I use set expression for limiting the total to based on the current year value?
Thanks,
AP.
Never mind removed the "=" sign and it worked..
new expression is
sum({$<ORD_YR ={"$(=(year(Today(0))))"} >} AMT)
Never mind removed the "=" sign and it worked..
new expression is
sum({$<ORD_YR ={"$(=(year(Today(0))))"} >} AMT)
Hi,
Try this
sum({$<ORD_YR ={"$(=(year(Today())))"} >} AMT)
Regards,
Jagan.
Hi,
Check with this
sum({$<ORD_YR ={"=$(=num(year(Today())))"} >} AMT)
OR
sum({$<ORD_YR ={$(=num(year(Today())))} >} AMT)
Regards,
Celambarasan