Support Board
Date/Time: Sun, 02 Nov 2025 05:01:44 +0000
Post From: cumulative sum of study for the week!
| [2024-12-18 23:01:02] |
| Sawtooth - Posts: 4282 |
|
You could also do it with the Spreadsheet Formula study, with a formula like this in its Formula field: =IF(AND(WEEKDAY(BARDATE)=1,HOUR(BARTIME)=18),ID1.SG1,ID1.SG1+ID9.SG1[-1]) where ID1.SG1 is the study and subgraph to cumulatively sum, and ID9 is this Spreadsheet Formula study. This will begin the cumulative summation every Sunday at 18:00. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#WEEKDAY_Function Date Time Of Last Edit: 2024-12-19 01:32:15
|