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?