I need a column whose value wil be either 'Yes' or 'No' based on other column.
For eg. The values of the column will be Yes if the item(which is another column) is currently on discount and the value will be No if it is not currently on discount.
Please help me on this.