Toggle parameter to display value in percent or number value

• gjoelson 29755

  SSC Eights!

  Points: 848

  More actions

  October 24, 2019 at 3:57 pm

  #3691702

  Hello,

  I'm trying to see if I can toggle report values from a number value to a % value , using a parameter or other mechanism.

  My values in the dataset present as a number, but have a need to view that same number as a % of a total.

  I'd like to do this in the report itself rather than the dataset if possible.

   

  Thanks!

• drew.allen

  SSC Guru

  Points: 77012

  More actions

  October 24, 2019 at 4:11 pm

  #3691708

  The easiest thing is to probably have two fields one with the number and the other with the percent of total and to load one as visible and the other as not visible.  The initial visibility could be hard-coded or based on a parameter. You could also have a button to toggle the visibility of both fields.

  Actually, I'd prefer it if both fields were always visible on the report.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA