What i would have done, if i am referencign that number many places, i will create a var-repeating group and inside it i do a search with two date constraint.
Start date >= Sale Created date say 01 August 2024
End date >= Sale Created date say 10 August 2024
this will only return all the sale between 1st August till 10th August and then do a sum.
if its confusing book a meeting in profile and we will do it together. i would love to help.
Hi, thanks for the reply, the way you are stating it sounds like something fixed within the repeating group, the user needs to be able to choose the 2 dates he wants results for
you can add constraint inside do search, you use constranint one for start date and one for end date, now its your choice how you ask user for date. or you can use Today, This week , This month, this year, and depending on user choice you know when is start date and when is end data.