Question
4
Replies
3117
Views
Posted: May 11, 2016
Last activity: September 5, 2017
Closed
We have a scenario where we want to take sum of a particular property in a Page list based on certain condition.
We have a scenario where we want to take sum of a particular property in a Page list based on certain condition.
Eg: Customer has 10 products as Page list, we want to take sum of price for all 10 products where product is not expired.
Is there any function available for this in Pega?
Message was edited by: Marissa Rogers - added category
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
This should work as it has been used in @baseclass.pxUIGalleryGetTotalCount Pega OOTB data transform.
Posted: 3 years ago
i dont think we have a OOTB function to select (based on a condition) and total the values
Hi Rohit,
I'm not aware of an OOTB function that would do this for you, however you could likely accomplish this using a Data Transform step that loops through your pagelist, check's against your condition, and then updates the property where you're storing the sum. Something like this might work for you (you would want to replace the "Always" when condition with your own comparison/condition):
Hope this helps!
-Kurt