7 Replies Latest reply on May 8, 2017 2:47 AM by Ben Powis

    ELSEIF calculation showing multiple values

    Ben Powis

      Hi all,

       

      I have made a calculation to assign colours to a report based on value, percent of total. However, when I use this field by dragging it onto the colours shelf it's assigning multiple values, instead of just one. Below is another view of the data which illustrates this better - in this screenshot the actual 'percent of total' figure is the sum of the bits broken down into different colours, I have also added my calculated to the screenshot - can anyone tell me what's happening here?

       

      Colour Key.PNG