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
Pegasystems Inc.
US
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
Coforge DPA Pvt Ltd
IN
@sum(.PageListName().PropertyName) this should work
Pegasystems Inc.
US
This should work as it has been used in @baseclass.pxUIGalleryGetTotalCount Pega OOTB data transform.
Staid Logic
US
i dont think we have a OOTB function to select (based on a condition) and total the values