Get grid column total from a business view FDA
I'm trying to get the total value of amounts in one of the columns of a business view that is displayed in a grid, and display it in a different text field.
I tried to dynamically add the values of the current business column in the Grid Record is Fetched event, but the problem with this is that it only adds the values of the rows currently displayed in the grid, and not all of the rows. This won't work since my table has 13k + records.
Any idea how to get this sum/total?
Thanks.