Login Page - Create Account

Support Board


Date/Time: Fri, 07 Oct 2022 09:46:36 +0000



Post From: Time Period Volume (and Text Display)

[2021-09-16 07:40:39]
User907968 - Posts: 722
This error makes sense, since the IF statement is basically computing the sum at that exact time, else it's returning an empty cell.

No, if your study ID is set correctly in the formula, it will only return 0 up until the volume is first calculated, after which it will return the last calculated volume, i.e. the calculated volume is copied from the preceding index.

What is the study ID of your Spreadsheet Formula, this need to be inserted in place of 'ID1' (if not ID1).

=IF(BARTIME=TIME(09,34,00),SUM(V[0:-4]),ID1.SG1[-1])