Question

5
Replies
2269
Views
Close popover
Christina thornlow (Christinat9806)
AAA

AAA
US
Christinat9806 Member since 2018 23 posts
AAA
Posted: November 1, 2018
Last activity: November 5, 2018
Closed

How to sum a pagelist in datatransform

HI, I am the below to sum up the ProductCost property returned from a datapage list. I am getting incorrect results when more than one row is returned. It seems like it is summing up the the second result twice. i.e. if the first row's product cost is 50 and the second one is 30 then I get a total cost of 60.00.

set .TotalCost = @sum(D_ProductList.pxResults().ProductCost)

I have attached the pxResults from the clipboard.

Can you please advise how to get the correct sum results.

***Edited by Moderator: Pallavi to update platform capability tags***

Low-Code App Development Reporting
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.