9 Replies Latest reply: Feb 18, 2015 11:40 AM by Jyothish KC

# Searching sums

Greetings,

I would like to search sums. I have vouchers which have separate line amounts. I would like to be able to search by the amount of the voucher. This gives me the amounts that I can search, but I am not sure how to search them.  =sum([LineAmount],[VoucherNumber])

I would ike to be able t search for vouchers between \$100.00 and \$500.00.

I have been trying to solve this for too long. Has anybody ever done this before?

Thanks,

Frank

• ###### Re: Searching sums

cud you share your app or data

• ###### Re: Searching sums

I am sorry. THere is too much data even if I pared it down.

• ###### Re: Searching sums

I guess, this is possible in script level.

If you want an expression in  search object,first you have to calculate tat expression as a field in script part

• ###### Re: Searching sums

Hi

try like this:

Aggr(sum([LineAmount]),[VoucherNumber]) this will give the sum amount based in the voucher numbers.

Then you can search with the sum

• ###### Re: Searching sums

THis is getting closer to what I am looking for. This is the question that is being asked: Show me vcher totals between \$100 and \$1000.

• ###### Re: Searching sums

Hi Frank,

Try to create two variable Var1 and Var2, one for your lower limit of voucher and one for the upper limit.

In chart try to something like this:

if( [LineAmount] >= Var1 and [LineAmount]<=Var2, Aggr(sum([LineAmount]),[VoucherNumber]))

Hope it helps.

Regards

KC

• ###### Re: Searching sums

if

(Sum([Check Amount])> NUM#(vLoStrat) and sum([Check Amount]) < NUM#(vHiStrat),sum([Check Amount]))

I was able to use this. Thank You KC!

• ###### Re: Searching sums

You are welcome