I want to get volume between time range.
i.e. sum of volume between 9:15AM to 10:00AM.
Below solution works but it only shows volume during 9:15 to 10:00. After this time volume showing {EMPTY}. I want to have voume sum till end of the day.
Take 10 more minutes out of your precious time, and read what you have written.
Then re-phrase what you really want and in such a way that others can understand clearly.
Then maybe someone will help you.
I just wasted my time trying to figure out what you want and then thought, no point beating around the bush.
Consider adding ValueWhen()
to your solution if you want the sum to "extend" through the end of the day.
Hi @travick
I know this topic is old, but I'm also having trouble when I want to calculate the cumulative total volume between two specific dates. My code is as follows and it does not run when the result Sum = 0, please help:
StartDateTime = ParamDate("Start Date","2023-08-01",0);
EndDateTime = ParamDate("End Date","2023-08-30 ",0);
SumVolume = SumSince(TimeNum() >= StartDateTime AND TimeNum() <= EndDateTime,Volume);
Filter = 1;
AddColumn(SumVolume,"Sum",1.2);
printf ("start date"+ StartDateTime);
printf ("\n end date"+ EndDateTime);
printf ("\n TimeNum "+ DateNum());
printf ("\n sum "+ SumVolume);