0

I'm trying to calculate a percentage of a filter against a total number and show in symbology so total number 583269 (Plots) formula is "Column A" > -123 (gives a result of 582962) I would like to show what the percentage of that result against the total so it should be read 99.947%

Improve this question
2
  • 1
    Using which software? Commented Nov 9, 2023 at 16:17
  • i'm using QGiS 3.34.0-Prizren Commented Nov 9, 2023 at 16:20

1 Answer 1

Reset to default
1

You can get the total of the filtered values by using the sum function and its optional filter argument. Get the overall total by applying the sum function with no filter:

sum("Column A", filter:= "Column A" > -123) / sum("Column A") * 100
Improve this answer
1
  • Thanks i will give it a go Commented Nov 9, 2023 at 17:48

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.