@Brian Cafferelli I created this post to inform you that your formula in the following blog is not correct. Gross Margin is (Revenue - COGS) / Revenue * 100. You were dividing by COGS in your blog post.
I could not figure out another way to notify you.
https://community.quickbase.com/blogs/brian-cafferelli1/2021/04/19/supercharging-summary-reports-with-new-aggregation​
------------------------------
Matthew Lysinger
------------------------------
Question
Blog Post Correction
This topic has been closed for replies.
Unrelated to the blog post formula but related to the new summary report formulas--unlike typical formula/field name behavior, the summary report formula fields/variables currently do not auto-update the name of the field/variables if the field name has changed.
It appears the defined summary variables (step 1) update properly, however the fields/variables in the summary report formula (step 2) need to be manually updated if the field name is changed.
------------------------------
Alex Patterson
------------------------------
It appears the defined summary variables (step 1) update properly, however the fields/variables in the summary report formula (step 2) need to be manually updated if the field name is changed.
------------------------------
Alex Patterson
------------------------------
+17Hi Matthew, thank you for bringing that to our attention! I will get the blog post corrected.
------------------------------
Brian Cafferelli
Product Marketing Manager | Quick Base
------------------------------
------------------------------
Brian Cafferelli
Product Marketing Manager | Quick Base
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.