Business Requirement to calculate metric calculation for certain category row by row basis

[srisiva55]

Hi All, I had requirement that states if product name like 'Jacket %' Or Product name like 'Shirt%' then expected value =Product Cost/1000 Other wise keep value as it is for rest of product names. How to do this in Query Edictor by adding new calculated column. Please help.  So below Product Names especially for Jacket, Shirt appended with some other text so I need to choose Like operation only  for example : Product Name LIKE 'Jacket%' etc..

[MS_Sum · Accepted solution]

Hi @srisiva55 

1. Add a Calculated Column and use the formula mentioned below and see if it works. Change the column values as per your table

Expected Value =

IF(

    OR(

           LEFT([Prod Name], 6) = "Jacket",

        LEFT([Prod Name], 5) = "Shirt"

    ),

    DIVIDE([Prod Cost], 1000),

    [Prod Cost]

)

If the suggestion helps, give a kudo and mark my reply as a solution  🙂