filtering

[jadams123]

Hi guys:

this is frustrating me.

I cant seem to get this formula correct:

= Sum( {$<GLYEAR = {$(#=MAX(GLYEAR))}, //THIS IS WORKING

DAYNUMBER>=2400 and DAYNUMBER<=2449,  //Treat DAYNUMBER as date. THIS IS NOT WORKING

CUSTOMER_NAME = {*} - {PERFECT INC.}, //THIS IS NOT WORKING

CUSTOMER_TYPE = {*} - {ITC}, //THIS IS WORKING

CREDIT_FLAG = {YES}>} AMOUNT )//THIS IS WORKING.

THIS IS WORKING means...if I try only this criteria it works as soon as i add other criteria (this is not working criteria = daynumber and customer name) it doesnt work.

Thanks,

J

[marcus_sommer]

Try it with:

= Sum( {$<GLYEAR = {$(#=MAX(GLYEAR))}, //THIS IS WORKING

DAYNUMBER = {">=2400<=2449"},  //Treat DAYNUMBER as date. THIS IS NOT WORKING

CUSTOMER_NAME -= {'PERFECT INC.'}, //THIS IS NOT WORKING

CUSTOMER_TYPE = {*} - {ITC}, //THIS IS WORKING

CREDIT_FLAG = {YES}>} AMOUNT )//THIS IS WORKING.

- Marcus

[rubenmarin]

Hi Joe, try with:

= Sum( {$<GLYEAR = {$(#=MAX(GLYEAR))}, //THIS IS WORKING

DAYNUMBER={">=2400<=2449"},  //Treat DAYNUMBER as date. THIS IS NOT WORKING

CUSTOMER_NAME = {*} - {'PERFECT INC.'}, //THIS IS NOT WORKING - added simple quotes

CUSTOMER_TYPE = {*} - {'ITC'}, //THIS IS WORKING -it can work but I added the simple quotes

CREDIT_FLAG = {'YES'}>} AMOUNT )//THIS IS WORKING. it can work but I added the simple quotes