How to use average function in an Activity
Hi,
I have a calculated field that needs to compute for an average.
1. @average(PageName.pxResults.PropertyName) - returns an error
2. @average(PageName.pxResults().PropertyName) - returns only the property value of the last row in the generated list/report
Question is how to properly compute for an average using the average function / expression?
Thank you
Accepted Solution
Pegasystems Inc.
US
Hello,
There are two ways to use the average function. One is as Deva Prathapanei suggests, passing in to numbers and getting an average returned. The other is to pass in a ClipboardPropertyCollection object and the function will walk through it and return an average in BigDecimal format.
Thanks,
Mike
Cognizant
PH
Hi Deva,
I'm getting an error when using @average(.PropertyName) :
Invalid expression or reference: No suitable instance found
[seeking]
@(null:null).average(String)
Swedbank AB
SE
average function will do average of two numbers. So you need to pass the two properties to function as below.
@average(.PropertyName1,PropertyName2)
Accepted Solution
Pegasystems Inc.
US
Hello,
There are two ways to use the average function. One is as Deva Prathapanei suggests, passing in to numbers and getting an average returned. The other is to pass in a ClipboardPropertyCollection object and the function will walk through it and return an average in BigDecimal format.
Thanks,
Mike