cancel
Showing results for
Did you mean:
Creator II

## p()

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

1 Solution

Accepted Solutions
Partner - Champion III

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

5 Replies
Specialist

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).

Partner - Champion III

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

MVP

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

Creator II
Author

Thanks for the explanation!!

Not applicable

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?

Community Browser