How to insert a conditional column?

[Anonymous]

Hi,

I have a sales table that contains the client, cluster client, value of the product. I want to add a column that shows a discount for the client, based on its cluster. For instance: if it belongs to Cluster 1, it should have a discount of 5%, if Cluster 2, a discount of 15% and so on.  How can I do that?

[Fowmy · Accepted solution]

@Anonymous 

In PQ, click on add custom column, then enter the following code to add the logic for discount

=if [clusterclient] = "Cluster1" then 0.05 else if 
[clusterclient] = "Cluster2" then 0.15 else null