Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
cud you share your app or data
I am sorry. THere is too much data even if I pared it down.
could you please upload a sample data.
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
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
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.
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
if
(Sum([Check Amount])> NUM#(vLoStrat) and sum([Check Amount]) < NUM#(vHiStrat),sum([Check Amount]))
I was able to use this. Thank You KC!
You are welcome