Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Create one decimal only in specific area Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 6:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:21 AM
Points: 58, Visits: 191
Goal:
Make the column [Internet Average Unit Price], [Internet Sales Amount] and [Internet Total Product Cost] with Arizona area to have one decimal only. The remaining numbers in different City, State province to have non decimal value.

Problem:
I tried finding a solution for it but I failed.

Information:
*Using AdventureWorks DW 2012 multidimensional
*The datasource is SSAS.
*The list in the picture is not before affected in format. In other words, it is raw data from SSAS.


  Post Attachments 
picture.png (6 views, 171.08 KB)
picture2.png (5 views, 122.44 KB)
Post #1513863
Posted Wednesday, November 13, 2013 7:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 5, 2014 7:58 AM
Points: 239, Visits: 1,186
Hi,

This can be done by using an expression on the format property for each of the 3 fields required.

The expression for the format property would be something like;

=iif(Fields!State_Province.Value="Arizona","N1","N0")

This would fix the format for 1dp for the Arizona group and 0dp for everything else.
Post #1513878
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse