Calculated attribute used in attributes drawer on right side of reconciliation

Summary

Calculated attribute required to sum all the transactions functional currency amount when it meets a criteria

Content

Hi,

We have a numerical custom attribute available in the attributes drawer of the reconciliation (reconciliation level). The attribute name is 'Unreconciled/AgedAmount In LC' we also have another attribute there with name 'Traffic Score'

We need make 'Unreconciled/AgedAmount In LC' as calculated attribute to sum all the functional currency transactions amounts when 'Scoring BSSC' (attribute used in transactions) contains the value updated in 'Traffic Score' (attribute used at reconciliation level showing in attribute drawer of reconciliation) for the respective reconciliation period (i.e.currently displayed period)