2 Replies Latest reply: Nov 6, 2012 5:17 AM by Helen Pippard RSS

    Concatenate in a pivot table remains same value

    Helen Pippard

            

      Hello

       

      I have written the following and it returns a value of 03:06

      When I add this formula to a pivot table which has month across the top, the formula remains at 03:06 for every month

       

      =

       

      Time(RangeFractile(.5, $(=Concat(If([Patient Admitted?]=1,[Total Wait]), ',') & ',' & Concat(If([ADMISSION_FLAG]='Y',CONCLUSION_WAIT_MINS), ','))

      Could you kindly help me rewrite the formula so that it is not static and will change for every month in the pivot table

       

      Kind Regards

      Helen