Macro calculation of a bucket with variable days

[Former Member]

Hello,

I want to realize a macro with the following functionality in a SNP Planning Grid:

The macro should calculate the bucket from 'today + 40 days' (the number of days could be variable; I will use a variable or a master data extraction)

In the next step I want to realize that the calculated bucket is ready for accept input.

Please give me some information how I can realize this issue.

Thanks

H.Becker

[Former Member]

Hi,

thanks for your answer - your functionality works.

Kind regards

Heinz

[m_manimaran]

Hi,

The macro function BUCKET_DATE_IN() can be used for this. I tested this. It worked fine. BUCKET_DATE_IN() will find whether the given date is falling in the bucket or not. If falling will return the value 1. Based on that we can make the entry in the corresponding bucket

New step : ( 8 Iterations : M 05/2011; M 12/2011 )

Action Box:

LAYOUTVARIABLE_SET( 'RESULT' ;

BUCKET_DATE_IN(

TODAY

+ 30 ;

Row: Vehicle's Past Mileage ( Frm M 05/2011 )

) )

IF

Condition:Date falls in the bucket

LAYOUTVAR_VALUE( 'RESULT' )

= 1

Row: Vehicle's Past Mileage ( Frm M 05/2011 ) =

10

ENDIF

Please try and revert.

Regards,

Manimaran M.