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

7
Replies
7742
Views
chuat Member since 2011 2 posts
PEGA
Posted: Jun 12, 2015
Last activity: Mar 16, 2018
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

Posted: 9 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!!

To see attachments, please log in.
Posted: 8 years ago
Updated: 8 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

To see attachments, please log in.
Posted: 7 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? 
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