APO DP Macro to perform calculation for a particular month in quarter.

[yadagiri]

Dear experts,

We have a requirement to perform calculation for a particular month in Quarter and I am not sure of how this could be achieved and request to help.

Ex: Business requirement

When I am in 1 month of the Quarter>>>No calculation should happen.

When I am in 2nd month of quarter>>>Calculation should happen

When I am in 3rd month of quarter>>>No calculation should happen.

Please suggest ways of achieving above business requirement.

Regards

Ashwin

[thomas_schulze2]

I'm assuming you have a DP planning book with monhtly buckets then you can use a combination of macro function MONTH() and BUCKET_B/EDATE() to dervive the month number of the current processes column:

IF

MONTH( BUCKET_BDATE (

row: forecast * --> chose "column attributes"

) ) = 2 or 5 or 8 or 11

THEN ....

Regards

Thomas