Discussion

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.

Group Tags

Comments

Keep up to date on this post and subscribe to comments

June 13, 2015 - 12:28am

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!!

February 12, 2016 - 8:26am

This is available in 7.2.

August 19, 2016 - 5:20am

can you elaborate how can we achieve this in 7.2 ?

August 25, 2016 - 12:50pm

Hello,

Thank you for your question. This link may provide more information.

https://pdn.pega.com/sites/pdn.pega.com/files/help_v721/procomhelpmain.htm#rule-/rule-declare-/rule-declare-expressions/new.htm

Thanks,

Maryrita Styer

Community Manager

 

Maryrita | Community Moderator | Pegasystems Inc.

August 29, 2016 - 11:10am

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

December 12, 2016 - 10:07am

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.

February 18, 2018 - 2:46pm

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?