Talking with a few customers we have found the need to add a type of Percentage to a Formula field in Data Designer.
When trying to build out there are a number of times when they would like to use this internally but are limited to number, boolean, or string.
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Hi.
Yes, right now we don’t have a Percentage data type but we can calculate the percentage with the help of Formula fields.
we have a workaround to calculate the percentage in DD using Formula fields.
In your data set, select the “Add Formula Field” button.
Screenshot:
Now the formula window will appear. Select the DataType as Number and the Expression Type as Numeric Expression and provide the decimal places how many we want to show in the output.
Screenshot:
In the formula text box create your formula as per your requirement and save it. And just do Preview the task.
Screenshot:
Thanks.
Talking with a few customers we have found the need to add a type of Percentage to a Formula field in Data Designer.
When trying to build out there are a number of times when they would like to use this internally but are limited to number, boolean, or string.