Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Script to set up Goals % and Value

Topic Labels: Scripting extentions
298 1
Showing results for 
Search instead for 
Did you mean: 


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?


1 Reply 1

Hi @Sam_Mitrani - I’ve wrote a post about a similar scenario here - it might help you: