3 Replies Latest reply: Jan 22, 2015 9:09 PM by jagan mohan rao appala RSS

    GetFieldSelections in Set Analysis

      I need some help with finding an alternative go below:

       

      = NUM(Avg({$<INSPECTION_ITEM={'Overall Satisfaction.'},
      InspectionMonth = {'$(=GetFieldSelections(Month))'},InspectionYear = {'$(=GetFieldSelections(Year))'},Month={'*'},Year={'*'}>}INSPECTION_SCORE_RAW),'#.##')

       

      Basically I am trying to have InspectionMonth be whatever the user selects in the Month field. Unfortunately the way our data works there’s so many dates, Request Date, Closed Date, Inspection Date, etc.. So I have a main calendar, and a couple other calendars to be referenced. . I opted out to having multiple month/year selectors on the page so the user doesn’t get confused. However that is causing me to go kind of crazy in some of the calculations.

       

      All suggestions are very much appreciated,

       

       

      PS,

      I originally used:

       

      = NUM(Avg({$<INSPECTION_ITEM={'Overall Satisfaction.'},

      InspectionMonth = P(Month),InspectionYear = P(Year),Month={'*'},Year={'*'}>}INSPECTION_SCORE_RAW),'#.##')

       

      But It did not calculate correctly.