AnsweredAssumed Answered

filtered sum to be used in calculation

Question asked by AdamReed on Jul 30, 2012
Latest reply on Oct 22, 2014 by PatriciaAngelini


filtered sum to be used in calculation


I would like to get the sum of expenses that have not been applied, but exclude those that have been applied from the sum.  I would then like to use the sum in a calculation (deducting that amount from a payment to a client, and assigning it to the business).  My thought was:

If ( paid = "no" ; Sum ( amount of expense ) ; 0 )

...but this doesn't seem to be working properly.  Any ideas?  (Is this enough information?)

Thanks for any help,