Text to Number format conversion

Q&A
, , ,
1

Hi,

I posted previously here regarding the “Returning Text values in the Pivot table” as in this link:
Returning text values in matrix visual values - #4 by rama_kumar.

While we are waiting on the feature we are trying to use alternative method as it is important for our business. I am trying to convert text values to numbers so it can be aggregated in the Matrix visual.

Here is an example I was trying, values for {attribute_value} are “Critical (P1)”, “Approaching (P2)” and “Required (P3)”.

Is there any function that I can use to convert the extracted characters ie, 1 or 2 or 3 from text to numbers?

ifelse( {attribute_title} = ‘Priority’, left(right({attribute_value},2),1), NULL )

Text to Number
Text to Number2530×941 66.8 KB

2

Hello Rama,

Could you try below and see if it helps

ifelse(
{attribute_title} = ‘Priority’,
tonumber(left(right({attribute_value},2),1)),
NULL
)

OR

ifelse(
{attribute_title} = ‘Priority’,
parseInt(left(right({attribute_value},2),1)),
NULL
)

Thank you.

Cheers,
Deep

3

Thanks Deep,

ParseInt worked. There is no ParseText function. Similarly if I need to convert number to text, which function should work.

4

you may use toString()