How to get the average of a previous month in the current month ?

Options
tinathom
tinathom Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

Hi 

I have a grid where in I need to calculate the average of the commissions selected for a couple of months  and then  to send it to another grid of a different month. How do I do it ?
PFA screenshots
Need help urgently

Thank you 

Tagged:

Comments

  • tinathom
    tinathom Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Contributor

    Thank you for replying
    I used Timesum(Average) in a module that has no dimensions but it gave me a huge value.
    PFA screenshots @JaredDolich 

  • Curt866
    Curt866 Member, ALL USERS Posts: 3 New Contributor

    Has there been any fix created for this yet?

    MYiClubOnline

  • tinathom
    tinathom Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Contributor

    Hi @JaredDolich 
    Thank you for the help and the encouragement . This helped me a lot. Appreciate it.

    PFA the screenshots. 
    This looks good now right ?

Categories