Skip to Content
0
Former Member
May 26, 2010 at 07:05 AM

RUN script when category is not ACT

41 Views

Hi,

This is part of my necessary's script:

*SELECT (%FirstPlanMonth%, [FirstPeriod], "CATEGORY", "[ID] = '%CATEGORY_SET%'")

*SELECT (%PlanCategory%, [ID], "Category", "[ID] = '%CATEGORY_SET%'")

*XDim_Memberset Category= %CATEGORY_SET%,Act

*When Category

*IS ACT

*When PlanItem

*Is RP420004

*FOR %PeriodLoop2%=0,1,2,3,4,5

*REC(EXPRESSION=GET(time=PRIOR(%PeriodLoop2%),category="ACT"),category=%PlanCategory%,PlanItem= #RP420004accl)

*NEXT

*EndWhen //PlanItem

*Endwhen //category

-


what I wish to achieve here is when user select %CATEGORY_SET% = ACT, i dunt want it to perform this script..other than ACT I need to run this script.

The reason I use

*When Category

*IS ACT

because i need it as a trigger point for me to take last 6 months actual record for calculation current month budget value.

if i use :

*When Category

*IS not ACT

I will not able to do any calculation because I dunt have any other record other than ACT...

How can I do this??

thanks................

Edited by: Guik Meng Chiam on May 26, 2010 9:06 AM

Edited by: Guik Meng Chiam on May 26, 2010 9:08 AM

Edited by: Guik Meng Chiam on May 26, 2010 9:11 AM