Forum Discussion

talderton's avatar
talderton
Frequent Visitor
3 years ago

Horizontal bar charts

Hi everyone,   I have created the table shown below that shows the % of positive answers by students for each school. I have used the following calculation in my table:   Positive response perce...
Need Help
talderton's avatar
talderton
Frequent Visitor
3 years ago

Sure, please see below

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi talderton 

Based on the message on the picture, please remove the additional "]"

 

Best Regards!

Yolo Zhu

  • talderton's avatar
    talderton
    Frequent Visitor
    3 years ago

    Thanks.

    I am now getting this error message:

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi talderton 

      Please try the following code again

      Positive response percentage of students = DIVIDE (CALCULATE (sum('MACSIS 2019 and 2021 survey restructured'[Number of students])),CALCULATE (sum('MACSIS 2019 and 2021 survey restructured'[Number of students]),ALLEXCEPT('MACSIS 2019 and 2021 survey restructured','MACSIS 2019 and 2021 survey restructured'[Enumber]),'MACSIS 2019 and 2021 survey restructured'[Positive reponse]] in {"Positive","Negative"}))

      Best Regards!

      Yolo Zhu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

       

      • talderton's avatar
        talderton
        Frequent Visitor
        3 years ago

        No, sorry.

        Just back to the e'nd of the input was reached' error message again.