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