calculate the sum of averages across multiple records that have multiple variables in common

Hey @Smdrich

  • Are you using Salesforce? You might conceivably be able to this with SF Formula fields as this would give you the most flexibility for reusing these fields.

  • Are you building in api v1 or v2? Which Skuid version are you using?

I did check with our internal team and they mentioned that if you’re in V1, you can probably just use the math formulas for agg in Skuid labs (see the link below - these formulas basically surface skuid.aggregations.aggregate() in formula form). You’d just need to create your own key for finding matches if you want to match across multiple fields since the IF statement only checks a single field

https://github.com/skuid/skuid-labs/tree/master/experiments/formulaFunctions