Support Board
Date/Time: Tue, 26 Nov 2024 20:40:48 +0000
Post From: Spreadsheet formula randomly returns 0 - Why?
| [2023-10-09 20:22:55] |
| User61168 - Posts: 403 |
|
Hi Tom, Draw Zero values is set to "Yes" across all spreadsheet formula studies and draw style is "hidden". I tried running the recalculate study every second and it still sets to zero. Also tried delete and download all data. Happens in replay with tick accuracy as well. p.s. I am assuming its a zero and not a negative or invalid value as there is no way for me to tell what is happening with this formula. I also tried to put a audio sound alert in the formula study to alert when value=0 and there is no sound alert triggering. Just weird! |