7 Replies Latest reply on May 8, 2018 1:20 PM by sonam jha

    Having issue on formatting grouped column cell based on range value on Measure

    sonam jha

      Hi All,

       

      I am trying to format the cell based on range. I am able to get the result based on below formula. However this is not working on grouped column.

       

      Issue: if you see the profit ratio they are both above 0.2 but they are coming in red because of California city grouping.

       

       

      Formula

      Any help would be appreciated.

       

      Thank you.