2 Replies Latest reply on Sep 13, 2018 6:42 AM by Danielle Farrie

    Displaying values in annotation v. title

    Danielle Farrie

      In the attached workbook, I am trying to code the values of a table calculation into the title of the worksheet. For two of the table calcs, the value shows sucessfully. But a second table calc I'm using just to add text to show whether the value is positive or negative just shows ALL. The table calculation is a percent difference from first, and i have added an if statement so the value only shows for the last year in my data. It seems like the calculation is working properly because when I add the same fields to a mark annotation they appear fine. Any ideas on what i'm doing wrong?