3 Replies Latest reply on Oct 3, 2016 11:09 AM by Michael Hesser

    Help With Expresssion

    archana.chandra
      User IDRecord NoMONTHYEARPlan GRP
      111111000001January20151
      111111000002February20153
      111111000003March20152
      111111000004April20152
      111111000005May20153
      111111000006June20155
      111111000007July20154
      111111000008August20155
      111111000009September20154
      111111000010October20155
      111111000011November20154
      111111000012December20154
      111111000013January20165
      111111000014February20164
      111111000015March20165
      111111000016April20164
      111111000017May20165
      111111000018June20164
      111111000019July20165
      111111000020August20161

       

       

      I have data coming in first 5 columns . My requirement is to find Max of Plan Group  and compare it with previous plan Groups and give me indicators  as 0, if my most recent plan & data in Plan grp is matching and 1 if data is not matching .   I'm using

       

      IF [MonthYear] = {fixed[User Id]:max([endDate])}    to get max plan Group for User  . and  if [Plan GRP] = [Most Recent GRP] then 0 else 1 end ( to get Indicator )

      i am getting one max value for each User but  not against getting right data .

       

      the data should be like :

       

       

           

      User IDRecord NoMONTHYEARPlan GRPMost Recent Grpindicators( New calculated Column )
      111111000001January2015110
      111111000002February2015311
      111111000003March2015211
      111111000004April2015211
      111111000005May2015311
      111111000006June2015511
      111111000007July2015411
      111111000008August2015511
      111111000009September2015411
      111111000010October2015511
      111111000011November2015411
      111111000012December2015411
      111111000013January2016511
      111111000014February2016411
      111111000015March2016511
      111111000016April2016411
      111111000017May2016511
      111111000018June2016411
      111111000019July2016511
      111111000020August2016110

       

       

       

       

      Pls Help !!