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.