6 Replies Latest reply on Aug 19, 2018 2:13 AM by SUTEE PATCHOTASING

    Please kindly help to advise how to create formula

    SUTEE PATCHOTASING

      In the picture i use COUNTD( [Validated SKU]) create CountValidated SKU measures and next i input a customer name in rows and in columne i use a dimensions it count a number of product reference it show RCD SPD and WDA. I need a formula for show condition if RCD > 4 and WDA>5 if condition it collect it show Yes look like in Picture 2 it should show only 2 customer a number STL0070 and STL0112.

       

       

      Picture 1

       

       

      Picture 2

      CountCountValidatedSKU2 = If [CountValidated SKU] >= 4 THEN "Yes" ELSEIF