Trying to evaluate set analysis for range but only takes current month.

[#1]

Dear Experts,

Help with expression where v_FTM_FIRSTDATE=01/04/2014 and v_FTM_DATE=current month date. But still gives result for current month instead of whole range.

=sum({<PMCO_WERKS= {$(vWERKS)} >}{<ZDATE = {'>=$(v_FTM_FIRSTDATE)<=$(v_FTM_DATE)'}>}{<PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

[rajeshvaswani77]

Hi,

Can you remove the single quotes in the ZDATE?

thanks,

Rajesh Vaswani

[ecolomer]

try this:

=Sum({<PMCO_WERKS= {$(vWERKS)} >}{<ZDATE = {>=$(v_FTM_FIRSTDATE)<=$(v_FTM_DATE)}>}{<PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

[#4]

Thanks Enrique

but expression is showing error. Not working.

Regards

Ashif

[rajeshvaswani77]

Hi,

Please check this, the flower brackets seem to be not placed correctly.

=sum({<PMCO_WERKS= {$(vWERKS)},ZDATE = {>=$(v_FTM_FIRSTDATE)<=$(v_FTM_DATE)},PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

thanks,

Rajesh Vaswani

[jagan · Accepted solution]

HI,

Try like this

v_FTM_FIRSTDATE= MakeDate(2014, 4, 1)

v_FTM_DATE= Today()

=sum({<PMCO_WERKS= {$(vWERKS)} , ZDATE = {'>=$(=v_FTM_FIRSTDATE)<=$(=v_FTM_DATE)'}, PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

Also make sure that v_FTM_DATE and ZDATE values are in the same format.

Hope this helps you.

Regards,

Jagan.

[#7]

Thanks Rajesh,

Just check the snap. If you could help me out.

Regards

Ashif

[rajeshvaswani77]

Can you check if PMCO.ACPOS is a  valid field name? You can for now remove that, as well please check if PMCO.AMOUNT is a valid field name.

Thanks,

Rajesh Vaswani

[its_anandrjs]

It seems your expression is correct only introduce this in the expression

ZDATE = { ">=$(=v_FTM_FIRSTDATE) <=$(=v_FTM_DATE)" }

Also cehck the fields name weather it should be PMCA_ACPOS={'400'} AND PMCO_AMOUNT

Regards

Anand

[#10]

=sum({<PMCO_WERKS= {$(vWERKS)} , ZDATE = {'>=$(=v_FTM_FIRSTDATE)<=$(=v_FTM_DATE)'}, PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

this should work..

thanks

sudhanshu shrivas