It would be so cool to be able to calculate this somehow and then show the percent of growth between years.
Is there anyone that can help me write these calculation?
Thanks so much!!!!!
![Very Happy :D](./images/smilies/icon_biggrin.gif)
Posts: 18
Joined: Thu Apr 09, 2009 8:32 am Location: Missouri |
Is it possible to show on the same layout the number of appointments that month as well as show the number of appointments from the previous year same month.
It would be so cool to be able to calculate this somehow and then show the percent of growth between years. Is there anyone that can help me write these calculation? Thanks so much!!!!! ![]() Robin
|
![]()
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am |
Hi. You'd need a relationship that is true for the same month but the previous year. Then you can use aggregate functions like Sum() or Count() across that relationship to show the comparisons.
Let me know which layout in the calendar you'd like to do this on (and which version of the calendar you have) and I'll post some ideas for the relationship. John Sindelar
SeedCode |
Users browsing this forum: No registered users and 1 guest