Hi all,
I'm looking to create a formula that compares today's volume to yesterday's volume, between 9am and the current time for each day.
Formula should be something like "Yesterday's Volume (between 9am and Current Time) - 24 hours, divided by Today's volume (between 9am and current time)". Output would simply be a percentage, in a box/label, stating how today's volume compares to yesterday's volume, at this same time.
Cannot find a single thing online about a study like this so here I am trying to make it myself! Thanks for any help.
I'm looking to create a formula that compares today's volume to yesterday's volume, between 9am and the current time for each day.
Formula should be something like "Yesterday's Volume (between 9am and Current Time) - 24 hours, divided by Today's volume (between 9am and current time)". Output would simply be a percentage, in a box/label, stating how today's volume compares to yesterday's volume, at this same time.
Cannot find a single thing online about a study like this so here I am trying to make it myself! Thanks for any help.