Forum Discussion
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 below
EX: of new table with new column
Client Name Sales Price Segmentation
AAAA 1200 B
BBBB 500 A
CCCC 7500 D
Many thanks
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
3 Replies
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 requirementThanks but i have to set 2 paramiters Min and Max and not only 1
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
