Forum Discussion
Solved
Segmentation
Hi, i have a table with 2 columns (Client name, Saleprice) i need to add a new column "Segmentation" that it takes the parameter from Min and Max and put the value A, B, C and D from the table b...
Hi AlessandroBet
The previous code will work, because when you use >= , it will show you proper data
or try below code, here I have mentioned both range. Please change range as per your requirement= if [Sales Price] >= 5000 and <= 9999.9999 then "D" else if [Sales Price] >= 3000 and <= 4999.9999 then "C" else if [Sales Price] >= 1000 and <= 2999.9999 then "B" else "A"If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Hi AlessandroBet
If the Parameter table is fixed and parameter data are not changing
Then you can create a custom column in your second table with name Segmentation in use the below code
= if [Sales Price] >= 5000 then "D" else if [Sales Price] >= 3000 then "C" else if [Sales Price] >= 1000 then "B" else "A"
Let me know if it solve your requirement