How to use function in Set Analysis

[kamal_sanguri]

I want to replace {'201504'} with max(PERIOD), Any Idea on this

=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={'201504'}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))

[MK_QSL]

=if(GetSelectedCount(PERIOD)=0,

     sum({<PERIOD={'$(=Max(PERIOD))'}>}BUD_DOLLARS_CY),

     sum(BUD_DOLLARS_CY))

or

=if(GetSelectedCount(PERIOD)=0,

     sum({<PERIOD={'$(=Date(MonthStart(AddMonths(Date#(Today()),-4)),'YYYYMM'))'}>}BUD_DOLLARS_CY),

     sum(BUD_DOLLARS_CY))

[maximiliano_vel · Accepted solution]

Try

=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={$(=Max(PERIOD))}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))

[#4]

=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={"$(=max(PERIOD))"}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))

[Gabriel]

Hi,

To use any function inside Set Analysis you need = sign before the function

[kamal_sanguri]

Thank you very much for your expertise, I have one more question.. Different people gave me different functions.. and all of them worked.. for ex: if I put the max funciont inside " " or ' ' or even if I just write function without any one of them all worked.. so what is the difference and which is a better/correct way.

Thanks again,

-Kamal

[kamal_sanguri]

Thanks

[kamal_sanguri]

Thanks