0 Replies Latest reply: Dec 15, 2015 12:27 AM by Brijesh Maurya RSS

    ignore selection on list box other value

    Brijesh Maurya

      Hi,

       

      I Am Creating an Variable For QTD , YTD , MTD and WTD.

      Replace(

       

       

      if([%Period_Type]='WTD', 'WeekID={"$(=Max(WeekID)-1)"},Date={"<=$(=Max(Date))"},[Day (#)]=,[Week#]=,Month=',

      if([%Period_Type]='MTD', 'MonthID={"$(=Max(MonthID))"},Date={"<=$(=Max(Date))"},[Day (#)]=,Week#=',

      if([%Period_Type]='QTD','FiscalYear={"$(=Year(Max(FiscalYear)))"},QuarterID={"$(=Max(QuarterID))"},Date={"<=$(=Max(Date))"},FiscalMonth=,[Day (#)]=,MonthlyWeekNumber=',

      if([%Period_Type]='YTD','FiscalYear={"$(=Max(FiscalYear))"},Date={"<=$(=Max(Date))"},FiscalQuarter=,FiscalMonth=,[Day (#)]=,MonthlyWeekNumber=',

      'FiscalYear={"$(=Max(FiscalYear))"}'

       

       

      ))))

      ,chr(34),chr(39))

       

       

      I have a List box Value as Flag Containing Values .. Like Primary A, Primary B , Secondary B.

      I Have a Exp for 3 KPI

       

      fabs(Num(SUM( {$<$(vCurrentSet),Flag = {'Primary A}>}Sales)))

       

      fabs(Num(SUM( {$<$(vCurrentSet),Flag = {'Primary B'}>}Sales)))

       

      fabs(Num(SUM( {$<$(vCurrentSet),Flag = {'Secondary B'}>}Sales)))

       

      But when i am selecting list box field. Other Kpi Value get Change .. How to Avoid this...