Good afternoon everyone
I have an expression in an SSRS report that is a concatenation of two sum fields:
sum(iif(Fields!statecodeValue.value = 3, 1, 0)) & ", " & sum(iif(Fields!statecodeValue.value = 3, Cint(Fields!actualvalue.Value, 0))
The sum of the fields with a state of 3 is working but I can't for the life of me work out how to get the sum of the currency field to actually display as £123,000 - it's just 123000.
Any help in formatting the output would be much appreciated. FYI the data is coming from Dynamics 365 online so it's fetchxml query, using VS 2015 with reporting server up to 2014.