Support Board

Date/Time: Sat, 18 May 2024 04:05:33 +0000

Post From: Numbers bars calculated values- duration average

[2020-05-13 13:36:04] Link To Thread - Link To Post [Go To First Post]
User968625 - Posts: 256
thank you for offering to help I have the study Number Bars Calculated values(ID44) with the variable I want to see the average fo Bar Duration (SG30) - ID44.SG1 I tried a couple of options that both put out a zero (Text display): first, use the moving average study and chose the ID50 which chose me the list to chose from and it is there (bar duration)- Text display for a study shows 0.0 and I also tried spreadsheet formula =AVERAGE(ID44.SG30[0:-10]- Text display for a study shows 0.0 I think maybe it has to do with the number format of the Bar duration Date Time Of Last Edit: 2020-05-13 13:38:13