cancel
Showing results for 
Search instead for 
Did you mean: 

Formated search and currency

Former Member
0 Kudos

Hi

how can i have only a numeric data without currency in the result of a formatted search

$[$42.Number] doesn't match

Thanks

Sylvain

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sylvain,

The formatted search field has three parameters. $[$Item.Column.Type]. So in your case if it is not a matrix you should have $[$42.0.Number], if it is in a grid you should change the middle 0 to the number of the column, like $[$42.5.Number].

Hope it helps,

Adele

Answers (0)