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?
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.
Comments
RIS Plus, LLC
MVP - Business Apps
you use Sumindex field and calcsum.And Date Fillter
IBIZ Consulting Services,India