2 Aggregate Functions for same column in Data Grid
I am using a Data Grid and have a currency column. I set the Aggregate Function to be Sum. The user would also like to see the Average in a row below the Sum. I added the same column again and set its Aggregate Function to Average but it does not work. First off, the Aggregate Caption gets changed to “Average” for both the Sum column and the Avg column. Also, the average is not even close. It appears to be using values from the next column to the right even though I did pick the proper Attribute in the path. I thought of just adding a label below the data grid, which would look odd but might work. But I can’t find any way to take the rows from the Data Grid and call a Microflow without someone clicking a button. I did add an action button to the grid toolbar and called a Microflow passing in a list of entities from the grid and that actually does work. But it’s clunky. Does anyone have any other suggestions?