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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

Convert CHAR to NUMBER?

Avatar

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