Forum Discussion
Dynamic parameter that populates a column, and changes it's value based on customers/clients
Hi Anonymous ,
According to your needs, if you want to continue to classify customers based on numbers and continue the subsequent operations, you can use the Rank function to sort them in descending order. The largest number indicates the greater the importance of the customer. For further processing, you can use the if function.
like this:
M = if(number meet the condition,A,B)If you still can’t solve it, can you provide the expected results and test data, so I will answer you as soon as possible. Let me know immediately and looking forward to your reply.
Best Regards,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the quick reply.
Sorry I should have been more specific. Basically I want the user to be able to categorise certain clients with a number (the higher the number the more important they are), with this number then feeding into other calculations (that rate the customers overall value).
Hi Anonymous ,
According to your needs, if you want to continue to classify customers based on numbers and continue the subsequent operations, you can use the Rank function to sort them in descending order. The largest number indicates the greater the importance of the customer. For further processing, you can use the if function.
like this:
M = if(number meet the condition,A,B)
If you still can’t solve it, can you provide the expected results and test data, so I will answer you as soon as possible. Let me know immediately and looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.