7 Replies Latest reply: Nov 26, 2016 5:05 AM by Vineeth Pujari RSS

    GetField Selection in YTD

    shweta gupta

      Hi All,

       

      I have used get selection with if condition in my variable. Variables are giving desired vales when put individually (Without using = sign).

      but while taking in range it fails.

      Need Suggestion

       

      vYearStart= If(GetfieldSelections(Month)<=1,(Yearstart(Max(Date),0,4)),

                                 (IF(GetFieldSelections(Month)>1,(MakeDate(Year(Max(Date)),Month(Min(Date)),01)),(Yearstart(Max(Date),0,4)))))

       

      vYearEnd= If(GetFieldSelections(Month)>0, Date(MonthEnd(Max(Date)),'DD/MM/YYYY'), Date((Max(Date)),'DD/MM/YYYY'))

       

       

      Range : '>=vYearStart<=vYearEnd' : No Result on using Range.

       

       

      YTD = Sum({<Date={'>=$(vYearStart)<=$(vYearEnd)'}>}Qty) : No Result.

       

      Suggestions Please !!