Newbie Questions

Re: sum for specified date range

Hilary Stoupa — Thu, 30 Jan 2020 15:46:44 GMT

Ah, it is in a repeating table! Add another field to the repeating group in the form schema (you don't have to display it on the form) and leverage that as a helper field along with a form load rule. I've given this a try in this copy of the form.

Re: sum for specified date range

cbristol — Wed, 29 Jan 2020 01:13:10 GMT

Thank you so much for the reply. it is a library form and I am attaching a copy for reference. Expiration date is set for 365 days from occurrence date and is already set to format to gray when that date is reached however i would like the point value to also zero out for only that occurrence.

If that is not possible can i set the occurrence point total on top (currently set for Sum(pointvalue) to calculate the sum for only points in the last 365 days? If this is possible i would still have to zero out the points below but the total would be accurate year to date.

Thank you again for your help, i really appreciate the insight and knowledge

Re: sum for specified date range

Hilary Stoupa — Wed, 29 Jan 2020 00:31:44 GMT

Hi - is this a SharePoint List form? Or a library form? Here's a sample form - save the attached file locally, right click and select Design, then you can preview and try it.

sum for specified date range

cbristol — Tue, 28 Jan 2020 20:08:09 GMT

Hey!

I currently have a form that is designed to track total point values. I have an occurrence date and expiration date set up. The expiration date has a rule associated to apply conditional formatting (gray out box) when that date is reached which is 365 days after occurrence date. I have attempted multiple times to set a rule that when the expiration date was reached to today, zero out that point but have had no luck. Another option i was thinking would be to take the total which currently is set up as total(sum) and add some sort of rule to only total the points from the today and the past 365 days. Does anyone have any insight on how to set this up. Would it be a rule applied or simply a formula?

Thank you for any help!