How do I use sum within expression builder to perform calculations?

Hello,

I have created a data set that pulls inventory records, and then I dropped the fields within that data set into a table, such that the inventory records display in the table. Works fine.

Next, at the bottom of the table I want to perform a calculation by summing all the values in COL2 and subtracting from COL1, as in (COL1 - Sum(COL2)) How do I do this in expression builder?

Thank You for any and all help!

Find more posts tagged with

Comments

mwilliams

Select your table, go to the binding tab, and create the SUM aggregations that you need to do your calculations. Now that you have aggregation bindings in your table, you can access these values in your expression builder.