0 Replies Latest reply: Mar 28, 2018 7:43 AM by Dan Coen RSS

    Default Selection unless otherwise picked

    Dan Coen

      Hi,

      I am trying to get the below expression to default to Fiscal Year unless Fiscal Quarter Name Long or Fiscal - Period Name Year Short is selected in the filter pane. Below if the expression currently:

       

      =if(GetSelectedCount([Fiscal - Year])>0,

      if($(Surgical_Amount_Type)='Booked Amount',

      if(GetSelectedCount([Fiscal - Year])>0,

      $(aYearBookedToDate))

      ,$(aYearShippedToDate))

      ,

      if(GetSelectedCount([Fiscal - Year Quarter Name Long])>0,

      if($(Surgical_Amount_Type)='Booked Amount',

      if(GetSelectedCount([Fiscal - Year Quarter Name Long])>0,

      $(aQuarterBookedToDate))

      ,$(aQuarterShippedToDate))

      ,

      if(GetSelectedCount([Fiscal - Period Name Year Short])>0,

      if($(Surgical_Amount_Type)='Booked Amount',

      if(GetSelectedCount([Fiscal - Period Name Year Short])>0,

      $(aMonthBookedToDate))

      ,$(aMonthShippedToDate)))))

       

       

      I tried to add "=" to the Fiscal Year to default it and that works for Fiscal Year but ignores the Fiscal - Year Quarter Name Long and Fiscal - Period Name Year Short when selected.

       

       

      =if(GetSelectedCount([Fiscal - Year])=0,

      if($(Surgical_Amount_Type)='Booked Amount',

      if(GetSelectedCount([Fiscal - Year])=0,

      $(aYearBookedToDate))

      ,$(aYearShippedToDate))

      ,

      if(GetSelectedCount([Fiscal - Year Quarter Name Long])>0,

      if($(Surgical_Amount_Type)='Booked Amount',

      if(GetSelectedCount([Fiscal - Year Quarter Name Long])>0,

      $(aQuarterBookedToDate))

      ,$(aQuarterShippedToDate))

      ,

      if(GetSelectedCount([Fiscal - Period Name Year Short])>0,

      if($(Surgical_Amount_Type)='Booked Amount',

      if(GetSelectedCount([Fiscal - Period Name Year Short])>0,

      $(aMonthBookedToDate))

      ,$(aMonthShippedToDate)))))

       

      Any ideas how I can default it to the Fiscal Year expression but override that if the Fiscal - Year Quarter Name Long and Fiscal - Period Name Year Short is picked?