I need table on min and max input value

[#1]

HI!!

I have a table with the field in database or qvd is

employee code	name	hospital	bill_date	rate	qty	amount(rate*qty)
1245	smith	xyz	01-Jan-14	400	1	400
1245	smith	xyz	15-Mar-14	500	1	500
1245	smith	xyz	20-Mar-14	500	2	1000

now i want to show above table on min and max value insert by user

I have taken two input box of varibale minAmt and maxAmt

let suppose value inputed by user is minAmt vaiable=500 and maxAmt=500

with the expresion :  Sum({&<RATE={">=$(minAmt)<=&(maxAmt)"}>}Amount)

its working fine

but WHAT if my table is an accumulated table OR GROUP BY TABLE

eployee code	name	hospital	month	rate	sum(amount)
1245	smith	xyz	Jan	400	400
1245	smith	xyz	Mar	500	1500

i have tried  LIKE THAT:

Sum({&<RATE={">=$(minAmt)<=&(maxAmt)"}>}SUM(Amount))

BUT IT IS NOT WORKING..

[anbu1984]

You can use the same expression Sum({&<RATE={">=$(minAmt)<=&(maxAmt)"}>}Amount) for accumulated table.

[#3]

try:

Sum({<rate={">=$(=minAmt)<=$(=maxAmt)"}>}rate*qty)

Field names are case sensitive!

If field amount is calculated during reload, you may of course try also:

Sum({<rate={">=$(=minAmt)<=$(=maxAmt)"}>}amount)

reg,

D

[#4]

thnks for advice guys

but I dont want to search on amount now.....

I want to search on sum(amount)

suppose min value -=1500 and max value=1500

then it show only one row

1245

smith

xyz

Mar

500

1500

[#5 · Accepted solution]

I got the desire result...... actually I was applying the expression on rate it should be on amount

wrong: Sum({<rate={">=$(=minAmt)<=$(=maxAmt)"}>}amount)

right: Sum({<amount={">=$(=minAmt)<=$(=maxAmt)"}>}amount)

thnks all for who replied...