SUM IF AND

[BrianDH]

I am trying to get the total(sum) of a field based on more than one condition.  Suggestions?

=Sum({$<X_BANK_ACCT_KEY ={'RFND'}>}AND {$<X_BUSINESS_UNIT = {'80801'}>} AND {$<X_PAID_AMT <={'10.00'}>}, X_PAID_AMT)

Error in Expression

[sunny_talwar · Accepted solution]

Try this

=Sum({$<X_BANK_ACCT_KEY = {'RFND'}, X_BUSINESS_UNIT = {'80801'}, X_PAID_AMT = {"<=10.00"}>} X_PAID_AMT)

[BrianDH]

Perfect!!!!!!!!!  Thank you!!!