SAP Knowledge Base Article - Public

1704509 - Crystal Reports 2011/2013 does not take formatted Scale Factor for a Measure/Key value while creating a summary

Symptom

  • Crystal Reports 2011/2013 does not take Formatted Measure value while creating a Summary
  • Instead of Formatted Measure value, Summary takes the exact Measure value to do the summation operation
  • If the Formatted Measure value is dragged on to the detail section of the report, the Measure value is shown as it is formatted in the backend. (For eg. If a Key Figure value is 3,561,628 and Scaling for the object is set to 1.000. So, the output of the Measure value is 3,561,628 and Formatted Value will give 3,562)
  • Summary shows the exact Measure Value that is without Scale Factor

Environment

  • Crystal Reports Designer 2011/2013

Reproducing the Issue

  1. Create a BEx query with one Key Figure in it
  2. Go to the Properties of the Key Figure -> Display Tab and change the Scaling Factor property of the Key Figure to 1.000
  3. Save the query
  4. Create a new Crystal Report in Crystal Reports 2011/2013 designer using SAP BW MDX Query connection
  5. Insert a Summary based on your Key Figure used in the query and place it on the report
  6. You will observe that the exact Measure value is appearing and ignores the Scale Factor formatting for the Key Figure

Cause

Any Scale Factor formatting done for a Key Figure comes under "Formatted Values" for a Measure objects and whose output is String. String fields cannot be summarized  in Crystal Reports 2011/2013. Scaling needs to be done in Crystal Reports using formula on the Key Figure field.

Resolution

In order to summarize a Key Figure, we need to use the Value field of the Key Figure in Summary.

For performing a Scaling for the Summary, you can follow the below mentioned steps:

  1. Right click on the Summary Total
  2. Go to Format Field -> Common Tab -> Display String (X+2)
  3. Write the below mentioned code and click on ok

          ToText(Round(({Measure.value}/1000),0),0)

Note: In Crystal Reports 2008, the Key figure was not divided into Value, Formatted Value or Unit. As a result, the measure value can be summarized with the Scaling Factor set in the BEx Query Designer.

Keywords

Scale Factor for a Measure/Key value, Crystal Reports 2011, Summary, Crystal Reports 2013, CR2011, CR2013, multiply 1000, 1000 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013