Question

5
Replies
2088
Views
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
Share this page LinkedIn