Summing up within a date range

asemberengasembereng Member Posts: 220
I have two fields that i want to sum up to a date specified. For example i can have data all the way to February 2009 and if want it to be able to sum let say all the way to December 2008 depending on the month selected.
How can i achieve this?

Comments

  • DenSterDenSter Member Posts: 8,304
    The easiest would be to make the field that you want to sum a sumindexfield. Then all you need to do is set a date filter and do a CALCSUMS on that field and you're done. If you don't want to do a sumindexfield you coud program a loop and add the values one by one.
  • devu_13devu_13 Member Posts: 101
    Hi
    you use Sumindex field and calcsum.And Date Fillter
    Devendra Kr. Sharma
    IBIZ Consulting Services,India
Sign In or Register to comment.