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
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
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 :
*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??
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