5 Replies Latest reply on Nov 9, 2016 7:39 AM by Walt Reed

    help calculating monthly average

    Al Reynolds

      Hi Guys

       

      This seems simple, but perhaps i am missing something.

       

      I have a calculated field that works out a spend amount (in this case TLC 2)

      I have calculated the TLC value from the previous month

      I know want to compare previous month to the monthly average.

       

      How do i create a calculated field giving me AVG(TLC 2) value by month? As can be seen in the screenshot i cant just do an  AVG.

       

      the follow on from here is to then calculate the impact financially if scoring above or below average etc.

       

      Any ideas?