How can I use the rollupCurrencySum and only obtain certain records?

Question

Here is our use case:

We have a custom field with a year field.

Accounts has a 1 to Many relationship with the custom module

I want this

rollupCurrencySum($mymodule_accounts, "amount")

where

equal(related($mymodule_acounts, "year"), "2014")?

how can I limit my rollupCurrencySum to only this year?

Jeff Bickart · Accepted Answer

Hi Nikol, Conditional rollup is possible in the product using the following function : Function: rollupConditionalSum Description: Returns the sum of the values of $field in records related by $link where $conditionField contains something from $conditionalValues. Parameters: Relate $link, String $field, String $conditionField, List $conditionalValues Return Type: Number I hope this helps!