Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Convert CHAR to NUMBER?

user1694
Level 1
Level 1

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.

0 Replies