1 Reply Latest reply: Sep 9, 2015 5:42 PM by Jonathan Poole RSS

    Label for totals

    Mark Rudolphi

      I have put in a formula for labeling my total (average) of quarters.  It is ='Avg '&Year.  However if more than one year is selected it doesn't know which year and just puts in the text Avg without the year.  What am I doing wrong as I assumed it would know the year the subset relates to?

       

      Capture3.PNG