Discussion

7
Replies
6309
Views
X
CHUAT Member since 2011 2 posts
PEGA
Posted: 5 years ago
Last activity: 2 years 4 months ago
Closed

Feature request: Declare Expression cannot perform a sum() of a Page List values

The auto calculated values can only perform simple arithmetric calculation on single value properties on the same page or an embedded page. It does not allow a sum of a Page List, e.g. GrandTotal = Sum of Expenses().DailyTotal.

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development
Reply
Moderation Team has archived post
Posted: 5 years ago

Another good suggestion!! We do certainly have plans and are working on to improve the form builder to allow users to configure such auto calculations in a simplified manner.  


 


Thanks again for your feedback!!

Posted: 3 years ago

can you elaborate how can we achieve this in 7.2 ?

Posted: 3 years ago
Updated: 3 years ago

Hi,


In 7.2 you can create a calculated field that is either a custom calculation or uses one of hte aggregate functions such as Sum, Min, Max, or Average.


Here is an example:


 


Thanks,


Dennis

Posted: 3 years ago

Hi chuat,


Please give the context of the page list and the subscript in the expression builder of the declare expression. Then check it might be work.


Thank you.

Posted: 2 years ago
Hi All, 


 


Facing the below error while calculating the total based on a page list (using Pega 7.2.2)


"The expression (right hand side)— Invalid expression or reference: error Final Expression .Item_Price (decimal) can't be converted into the desired type (ClipboardPropertyCollection)"


 


Configuration details 


pyWorkPage 


---  Catelog (Page A)


                            - Item(1).Item_Price (Page B)


                             -Item(2).Item_Price (Page B)


 


pyWorkPage.Catelog.Item(1).Item_Price 


pyWorkPage.Catelog.Item(2).Item_Price 


 


I need to calculate the Item_Total = Item(1).Item_Price + Item(2).Item_Price


Item_Total (Decimal) single value of Class Page B


 


Declare expression configuration - Is it right way of configurations or anything need to be considered. 


 


Target Property - Item_Total


Page Context - .Catelog.Item()


 


Set Item_Total  = Sumoff (.Item_Price) using entries in which (.Item())


 


Any suggestion please? 
Share this page LinkedIn
Copied!