5 Replies Latest reply on Oct 27, 2016 9:19 AM by Joe Oppelt

    Best approach to spliting a Paramater float across a Table of percentages??

    Ben Shirley

      Hi all

       

      So i have a basic bar chart

       

      Categories as Row headings

      #Score as Column

       

      the #score becomes SUM(SCORE) and then i apply the ANALYSIS/PERCENT OF TABLE

       

      This all works..

       

      So now i have a number in a Parameter box, this is for the user to input this years budget allocation and for that budget to be divided across the percent of scores.

       

      Eg, If i had £100, and 4 Categories at 10%, 20%, 20% and 50%, I would expect £10, £20, £20 and £50

       

      I did try to make a Calculated field, but it seems very hard to do this based on the same Measure

       

      I am not really sure how to proceed here, any help would be appreciated, I am sure this is simple, but minds a blank!

       

      Thanks,

      Ben