Simple SSRS formatting (thousands and millions)

Something for your cookbook!
A simple form of SSRS formatting for thousand and million in two decimals.

Including a Euro-sign:

=IIF(Fields!MetricValue.Value>=1000000 , "'€' #,0,,.00"+"m",
IIF (Fields!MetricValue.Value>=1000, "'€' #,0,.00"+"k",
IIF (Fields!MetricValue.Value>=0," '€' 0.00",
IIF (Fields!MetricValue.Value<-1000000, "'€' #,0,,.00"+"m",
IIF (Fields!MetricValue.Value<-1000, "'€' #,0,.00"+"k", "0.00"
)
)
)
)
)

Without the Euro-sign:

=IIF(Fields!MetricValue.Value>=1000000 , "#,0,,.00"+"m",
IIF (Fields!MetricValue.Value>=1000, "#,0,.00"+"k",
IIF (Fields!MetricValue.Value>=0,"0.00",
IIF (Fields!MetricValue.Value<-1000000, "#,0,,.00"+"m",
IIF (Fields!MetricValue.Value<-1000, "#,0,.00"+"k", "0.00"
)
)
)
)
)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s