Number Functions in Data Designer Formula Fields

  • 21 April 2021
  • 1 reply
  • 7 views

Userlevel 3
  • Gainsight Employee: Veteran Rookie
  • 20 replies

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

Userlevel 7
Badge

Awesome!

Reply