1 of 1 people found this helpful
I don’t really know why the calculation would have a different outcome, but as a work-around you might want to try:
(86400-(TimeEq(‘Run Status’, ‘y’, ‘ ‘t’, 0)))/86400
Set the triggering not at midnight but for instance 1 AM and the Output Time Stamp to Relative to Trigger Time (*-1h)
If some additional data comes in after the trigger time of the calculation, then the results could differ (ie. some data at 12:30 come in timestamped for the previous day). If that is the case, then I would suggest running the analysis later.
For example, you could run the analysis at 6AM (periodic) but to look at the data of the previous day. The trick here would be to use the Advanced Options in the scheduling parameter to have the output still set to midnight:
Hope this helps,