Discussion

7
Replies
6593
Views
 Teng Hao Chua (chuat)
PEGA
Global Tech Enablement, Senior Instructor
Pegasystems Inc.
SG
chuat Member since 2011 2 posts
PEGA
Posted: June 12, 2015
Last activity: March 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.

Low-Code App Development
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 6 years ago
Posted: 13 Jun 2015 0:28 EDT
Vijay Vaddem (VijayVaddem)
PEGA
Senior Product Manager - Mobility
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!!
Posted: 4 years ago
Updated: 4 years ago
Posted: 29 Aug 2016 11:10 EDT
Updated: 29 Aug 2016 11:11 EDT
Dennis Grady (dennis.grady)
PEGA
Senior Director, Product Engineering, Intelligent Automation
Pegasystems
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
Posted: 4 years ago
Posted: 12 Dec 2016 10:07 EST
Dileep Kumar Balaga (Dileep Kumar Balaga)
Accenture Australia
Senior Decisioning Specialist
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.
Posted: 3 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?