Post reply

Toggle parameter to display value in percent or number value

  • 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!

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply