3 Replies Latest reply on Feb 6, 2019 5:20 PM by Shinichiro Murakami

    2 conditions Cannot mix Agg & non Agg

    NAYANA MADHEKAR

      Hello,

       

      I am wondering how to add two conditions to do the color coding:

       

      I want to fix this simple problem (I guess)

      Formula:

      CASE [Focus]

      WHEN 'Yes' THEN IF  [hours worked]<=110 THEN "Red" ELSE "Green" END

      WHEN 'No' THEN IF  [hours worked]<=50 THEN "Red" else "Green" END

      END

       

      Can I use a dimension like this for a condition?

       

      Its giving me an error - Cannot mix Agg and Non Agg

       

      I only have to check these two conditions I have described in my Formula Above.

       

      Attached is the workbook.

       

      Ty, any help is appreciated