0 Replies Latest reply: May 1, 2013 8:35 AM by Megan Langley RSS

    Percent through the month/quarter

      I need help with calculating the percent through the month and quarter in a couple of different views.

       

      The first is a straight text box that will display the percent through the quarter.

       

      The second is for conditional formatting. I have a pivot table with each month's performance compared to budget. I would to have conditional formatting for the percent through the month for each month. Therefore, since March is 100% over, anything over 100% is green. However May is only 3% through the month therefore anything over 3% would be green.

       

      Thanks for your help!