Skip to main content
sai_kumar
Helper ⭐️⭐️
April 21, 2021

Number Functions in Data Designer Formula Fields

  • April 21, 2021
  • 1 reply
  • 71 views

With April 6.23 Release, Gainsight has introduced Number Functions in the Formula Fields of Data Designer. The Number Functions allow admins to perform powerful calculations while applying transformation on a dataset. Following are the Number Functions available:

  • Abs
  • Ceiling
  • Exp
  • Floor
  • Ln
  • Log
  • Sqrt

Example Business Use Case: When there are companies with low ARR (<10k) and high ARR (> 1M) in the same chart, admins can now create a report leveraging the logarithmic function to view those companies better in the same chart.

For more information on how to use the Number Functions in Formula Fields, refer to the Formula Fields [sfdc] and Formula Fields [nxt] article.

Feel free to reach out with any questions or suggestions - docs@gainsight.com.

 

Happy Posting!

 

1 reply

dan_ahrens
Expert ⭐️⭐️⭐️
April 23, 2021

Awesome!

VP of Customer Success at Forcepoint