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

# ignore selection on list box other value

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...