Hi, is there a way to sum up values in the global table dynamically and display the total somewhere? Pls find the screenshot of the global table! Thanks
You could write a loop or you can use the table query to do it for you. Here's an example you can run in the script window and see the result:
Table result=Table.query("SELECT SUM([Col 1]) FROM GlobalTable1");
return result[1][1];
Perfect, thanks Jason! Do you know how to we can add the number to the Dashboard?
Are you thinking it would be dynamic as the table values change? Or calculated on a button press?
15 People are following this question.
