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
Posted: 4 years ago
Posted: 3 years ago
@sum(.PageListName().PropertyName) this should work
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