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

One thought on “Simple SSRS formatting (thousands and millions)

  1. these formulas miss the range between 0 and -1000.
    here’s my version.
    cheers!

    =switch
    (Abs(Me.Value) >=1000000, “#,0,,.00″ +”m”,
    Abs(Me.Value) >=10000, “#,0,.00” + “k”,
    Abs(Me.Value) >=0,”#,0;(#,0)”

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