Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have the following straight table. We also have Compliance as a field with three possible categories: COMPLIANCE, ENFORCEMENT and SUPPORT.
In the table below we would like is to show the count of each category. At the minute showing same one 3 times.
The current expression is Count(Compliance); however, when I've tried to amend to what I think will work If(Compliance)='SUPPORT' I'm not having joy. Please help...
Area | Neighbourhood | Count(Compliance) | Count(Compliance) | Count(Compliance) |
Irlam & Cadishead | Moss Vale | 490 | 490 | 490 |
Irlam & Cadishead | Falmouth | 119 | 119 | 119 |
Irlam & Cadishead | The Glaze | 410 | 410 | 410 |
Chris
Try Something like below..
COUNT({<Compliance = {'SUPPORT'}>}Compliance)
and SO ON.
Try Something like below..
COUNT({<Compliance = {'SUPPORT'}>}Compliance)
and SO ON.
Try
COUNT({<Compliance = {'SUPPORT'}>}Compliance)
Hi Luis, Manish
Thanks..both answers correct but can only mark 1 one of you as correct...
First Come First Serve