Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write in expression :
if([Fiscal Year] is not selected and [Fiscal Month] is not selected)
[Fiscal Year], [Fiscal Month] are filters.
eg,
=if ([Fiscal Year]=' ' and [Fiscal Month] =' ',
Sum({<[period_key]={$(vMaxPeriod)},[Fiscal Year],[Fiscal Month]=>}inventory_on_hand-qa_blocked_stock),
Sum({<[period_key]={$(vMon)}inventory_on_hand-qa_blocked_stock))
if(not getselectedcount([Fiscal Year]) and not getselectedcount([Fiscal Month]), ...true..., ...false... )
to know if a field has selections or not use GetSelectedCount(Field)
if(not getselectedcount([Fiscal Year]) and not getselectedcount([Fiscal Month]), ...true..., ...false... )