Creating an ALL prompt for numeric values

building semantic layer
1

This code is only working when fiscal year is a character.

@Select(Time Periods\Fiscal Year) in @Prompt('Select Fiscal Year(s): ',‘N’,‘Time Periods\Fiscal Year’,Multi,Free,Persistent,{‘ALL’},User:0) or ‘ALL’ in @Prompt('Select Fiscal Year(s): ',‘N’,‘Time Periods\Fiscal Year’,multi,Free,Persistent,{‘ALL’},User:0)

Is there anyway to create the same filter when fiscal year is a numeric, with out casting or changing it to character.

Thanks
Monty. :hb: :hb: :hb:

monty4u :us: (BOB member since 2006-12-12)

2

Not with “All” as the substitute. You would have to designate a numeric alternative like 0 instead.

@Select(Time Periods\Fiscal Year) in @Prompt('Select Fiscal Year(s): ','N','Time Periods\Fiscal Year',Multi,Free,Persistent,{0},User:0) or 0 in @Prompt('Select Fiscal Year(s): ','N','Time Periods\Fiscal Year',multi,Free,Persistent,{0},User:0)

Dave Rathbun :us: (BOB member since 2002-06-06)