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

    2 conditions Cannot mix Agg & non Agg




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


      I want to fix this simple problem (I guess)


      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



      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