Skip to main content
tracy_streetman
Contributor ⭐️⭐️⭐️
December 2, 2015
Released

Formula Calculations in Reports 2.0

Related products:CS Reports
  • December 2, 2015
  • 25 replies
  • 269 views
It would be beneficial for Reports 2.0 to have simple formula calculations available such as +, -, SUM, AVG, %.  An Example where this would be helpful is with Email Logs.  We have sent a survey and within Reports we currently can't report on the "Outstanding" surveys.  If we could create a report with a formula that allows us to subtract completed from sent we would be able to get this data.

    25 replies

    spencer_engel
    Expert ⭐️
    January 16, 2018
    Any update on this?
    olavo_zapata
    Contributor ⭐️⭐️⭐️⭐️
    May 2, 2019
    This still a dream??

    lila_meyer
    Gainsight Employee ⭐️⭐️⭐️
    May 2, 2019
    It's coming in the May 6.3 release!



    Lila Krutel, Dir. Global Education Services
    olavo_zapata
    Contributor ⭐️⭐️⭐️⭐️
    May 3, 2019
    Oh my Gosh! I like this.gif!... Looking to use it.

    sai_ram
    Expert ⭐️⭐️
    May 22, 2019
    Hi All, Here is a good news about the implementation of calculated fields in Report Builder.

    The Report Builder now offers a new functionality called Formula Fields. With Formula Fields in Reporting, admins can instantly create a formula field in Report Builder, based on their business requirements. These reports can then be consumed in all other functionalities of Gainsight, like: Dashboards, C360/R360, Success Snapshots, etc.

    Currently, in Gainsight, admins can also create Formula Fields in Rules Engine and Data Management, and can use them in reports.

    You can create Formula Fields of String, Date and Number Data Types.

    Formula fields can be applied only on MDA objects and you cannot create formula fields on the following objects: Email Logs, Email Raw Events and Unsubscribed Emails.

    Please follow this article for more information.