Count If Number format in Text Ojbect

[nigelapt]

Hi folks

I have this expression in a Text Object to count the values in the DWH Severity field where the severity equals Critical

='Critical '&Count(IF([DWH Severity]='Critical',0))

Value returned is 177342 but I need it to be 177,342.

Any advice would be greatly appreciated.

Thanks

Nigel

[Vegar · Accepted solution]

Try using NUM() to define your presentation

='Critical '&NUM( Count(IF([DWH Severity]='Critical',0)), '#,###.','.',',')

[nigelapt]

Hi Vegar, 

Thank you very much for taking time to look at my problem, and replying.

It's fixed!

I had been trying to get this sorted for days.

Thanks again.

Nigel

[Vegar]

I'm glad to be of help.

/Vegar