1 Reply Latest reply on Nov 20, 2017 2:36 AM by chris monger

    How to use FIXED for two different dimensions?

    Chadi Atie

      Hello Guys,

       

      I create this calculated field (see below) to fix the Country, and it works really well. But the thing is that I make another dimension FIXED as well in addition to the country. (The other dimension is called "Agency").

       

      How can I add it to my formula?

       

      { FIXED [Country]: SUM(IF [Tickets]=0 THEN [Number of Records] END ) }

       

      Thanks a lot guys,

      I appreciate your help

       

      Cheers

      Chadi