Question

[jadams123]

Hi All:

I want to be able to do this statement:

1) if max week -1 is between weeks 40 to 44 then P10.

This is my formula for max(Week -1):

=Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No])-1)}, CUSTOMER_TYPE -= {ITC}, CREDIT_CODE = {YES}>} AMOUNT )

This is my formula for max(period):

=Sum( {$<GLYEAR = {$(#=Max(GLYEAR))}, GLPERIOD= {$(#=Max(GLPERIOD))}, CUSTOMER_TYPE -= {ITC}, CREDIT_CODE = {YES}>} AMOUNT )

Thanks,

J

[jadams123]

My IT dept told me that in order for this code to work I have to select 2017 and weeks 1-XX. And its working.

Its not the perfect code...but it is working.

[vinieme12]

Then try MAx with the TOTAL keyword

Sum( {$<YEAR = {$(=Max(TOTAL YEAR))}, [Week No]= {"<=$(=Max(TOTAL [Week No])-1)"}, CUSTOMER_TYPE -= {ITC}, CREDIT_CODE = {YES}>} AMOUNT ).