extract_percent function reads percentage from text and returns the value as a decimal.
Note: This function is only available in Templates and can’t be used in Reporting.
Syntax
extract_percent(XX%)
Parameters
XX% should include a number currently in a text format.
Examples
extract_percent(50%) = 0.5