Forum Discussion

MatthewLysinger's avatar
MatthewLysinger
Qrew Trainee
4 years ago

Blog Post Correction

@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
------------------------------
Discuss the community

2 Replies

Sort By
  • AlexPatterson's avatar
    AlexPatterson
    Qrew Trainee
    4 years ago
    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
    ------------------------------
  • BrianCafferelli's avatar
    BrianCafferelli
    Qrew Captain
    4 years ago
    Hi Matthew, thank you for bringing that to our attention! I will get the blog post corrected.

    ------------------------------
    Brian Cafferelli
    Product Marketing Manager | Quick Base
    ------------------------------