question

LambellaJules avatar image
LambellaJules asked

How to format sum of currency field in SSRS expression that has a second sum(iif) in the expression

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.

Many thanks

Jules

ssrs-2012expression
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

LambellaJules avatar image LambellaJules commented ·

Oops thought I had better add that this expression is on a group, not in the details row.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.