Hi,
I have a table of orders, with their value in $. I wanted to create a dashboard that will show the current sum of the orders vs. a goal. Since there is no (as far as i found) a way to do that with the current apps, i thought of using a script.
Can someone share an example of a formula that will calculate the sum of raws in the tables and then will take a # and reduce that sum from it?
Thanks