Convert CHAR to NUMBER?

user1694

31-08-2018

Hi,

to introduce, i want to deduplicate a group of clients with multiple contracts keeping for each of them the line with maximum suscription level.

The problem is that data (Maximum amount) is on CHAR and i try testing calculation  MAX of amount per client or using deduplication ("entering expression") but the results are not logic.

I try to find a way to convert a CHAR data in NUMBER but with no succes. I have a user profile not admin.

Anybody have already had this problem?

Thanks to you.

Clément.

Accepted Solutions (0)

Answers (0)