Create one decimal only in specific area

• akirajt

  Right there with Babe

  Points: 762

  More actions

  November 13, 2013 at 6:56 am

  #286146

  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.

• Paul Keys

  SSC Eights!

  Points: 866

  More actions

  November 13, 2013 at 7:14 am

  #1666070

  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.