5 Replies Latest reply on Jul 30, 2018 11:43 AM by Naveen B

    Dynamic Reference Line for Multiple Filters

    Marcelo Souza

      Hi All,


      I made a simple calculated field to have a "dynamic" reference line by each Region when the user select the Region using a filter so the issue is how can I include a logic in the calculated field to have also a reference line when I selected all those 4 Regions? Actually I get no reference line when I selected all Regions.


      ATTR(IF [Plant Region1] ="LA" THEN 10

      ELSEIF [Plant Region1]= "NA" THEN 8

      ELSEIF [Plant Region1]= "EMEA" THEN 9

      ELSEIF [Plant Region1]= "AP" THEN 8

      ELSE 10