2 Replies Latest reply on Oct 17, 2018 10:08 AM by Michel Caissie

    Dynamic currency symbol for table

    Sonali chavan

      Hi guys,

       

      I have one dynamic field KPI_ALl which dynamically shows my selected KPI from Parameter. I have 9 KPI's in my dashboard.

      2 are volume KPI and rest are sales one.

       

      I have table like below:

       

      I want to shoe "$" symbol only for sales and not for others.  like this:

       

      I cannot change my table layout.

      Can someone plz suggest something.

       

       

      Sonali.

        • 1. Re: Dynamic currency symbol for table
          arvindgarg

          I would create two sheets one for Sales and other for volume.

          Then i will show one of them based on selection and hide another.

           

          It is like sheet swapping based on parameter.

          • 2. Re: Dynamic currency symbol for table
            Michel Caissie

            Sonali,

             

            you can make 2 copies of KPI_ALl , something like this;

             

            copy1

            if parameter = Volume  then volume measure

            elseif parameter = Sales then null

            end

             

            copy2

            if parameter = Volume  then null

            elseif parameter = Sales then Sales measure

            end

             

            set the default properties-Number format   of each calculation  for currency or no currency

             

            put both calculations in the view.

             

            when you change the parameter,  one copy will be null showing nothing , and the other one will show with the correct format

             

            Michel