Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Teng Hao Chua (chuat)
PEGA
Principal Technical Instructor
Pegasystems Inc.
SG
chuat Member since 2011 2 posts
PEGA
Posted: Jun 12, 2015
Last activity: Mar 16, 2018
Posted: 12 Jun 2015 22:51 EDT
Last activity: 16 Mar 2018 19:46 EDT
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.

To see attachments, please log in.
Low-Code App Development

  • Hemanth Reddy Nelapatla
Posted: 9 years ago
Posted: 13 Jun 2015 0:28 EDT
Vijay Vaddem (VijayVaddem)
PEGA
Director, Product Management, Case Management
Pegasystems Inc.
IN

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

To see attachments, please log in.
Posted: 8 years ago
Updated: 8 years ago
Posted: 29 Aug 2016 11:10 EDT
Updated: 29 Aug 2016 11:11 EDT
Dennis Grady (DennisGrady)
PEGA
Vice President, Platform Engineering
Pegasystems Inc.
US

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

To see attachments, please log in.
Posted: 8 years ago
Posted: 12 Dec 2016 10:07 EST
Dileep Kumar Balaga (DileepKumarBalaga)
Accenture Australia

Accenture Australia
AU

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.

To see attachments, please log in.
Posted: 7 years ago
Posted: 18 Feb 2018 14:46 EST
Sripada Venkata Aditya (SVAQuest)
Tata Consultancy Services Ltd
Technical Architect
Tata Consultancy Services Ltd
AU
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? 
To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice