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?
