Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Try
=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={$(=Max(PERIOD))}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))
=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))
Try
=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={$(=Max(PERIOD))}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))
=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={"$(=max(PERIOD))"}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))
Hi,
To use any function inside Set Analysis you need = sign before the function
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
Thanks
Thanks