I am trying to get a number of finalised cases to display in the title of a gauge chart.
I currently have this formula:
='Finalised Incidents = ' & if([Finalised Year] = vMaxYear,count([Incident Closed]))
It only displays Finalised Incidents =
This was working with a different formula but with this new formula (different calculation) the number does not display. The gauge however does display the correct number.