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)),



      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 !!