Need help on a formula

[#1]

In my formula below, I'm totaling all the revenues received in prior year that equal transaction code 18.

=sum({$ <Type={'Revenue'}, TC = {"> 18"}, CalYear={$(vPriorYear)}>}[Transaction Amount])

The formula works fine but I need to exclude a certain account number.  The field associated to the account number is  Acct#  and the actual account number is 59901

I am new to qlikview and would appreciate any assistance.

Thanks

[jaimeaguilar · Accepted solution]

Hi,

try like this:

=sum({$ <Type={'Revenue'}, TC = {"> 18"}, CalYear={$(vPriorYear)}, Acct# -= {59901}>}[Transaction Amount])

or

sum({$ <Type={'Revenue'}, TC = {"> 18"}, CalYear={$(vPriorYear)}, Acct# ={'*'}-{59901}>}[Transaction Amount])

regards

[#3]

Thank you.  It worked.