Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Please explan me, what we are telling in the below piece of syntax??
productID = P({$}productID)
complete expression->
sum{1<productID = P({$}productID),year={2014}>}sales)
Thanks!
Suraj
sum{1<productID = P({$}productID),year={2014}>}sales)
sum of all the sales where productId is among all the (P)ossible values for the 2014
P() means possible, in your expression, you are saying to take all the possible productID and year = 2014, i think you can replace the expression sum{1<productID = P({$}productID),year={2014}>}sales) to sum({<year={2014}>}sales).
sum{1<productID = P({$}productID),year={2014}>}sales)
sum of all the sales where productId is among all the (P)ossible values for the 2014
Hi,
Here in the expression P() means Possible and by expression sum{1<productID = P({$}productID),year={2014}>}sales) you get all possible rows of productID in the year 2014 and sum the sales value.
Regards
Anand
Thanks for the explanation!!
What about the 1 in the above expression sum{1<productID = P({$}productID),year={2014}>}sales)
Does it add anything to the expression, removing it would it not be the same?