Ans.Valid ranges is 1 to 1 billion; if you set a scaling factor of 1000, then the value 3000 is displayed as 3.
Q.Number of decimal places?
Ans. To round to specific decimal places, example 2 for dollar amounts
Q.what are the options for calculate result as – summation?
Ans.The sum of total values area displayed for example this could be used in reports where you use conditions; by default results in condition displays the report result and not the filtered(conditioned)totals; maximum;minimum;count all values—number of values;count all values<>0; average of all values; averageof all values<>0 ; standard deviation; variance; suppress result; first value; last value; summation of rounded values;
Q.What is an exception aggregation and give an example?
Ans.This defines how the key figure is aggregated in relation to exception characteristics usually a time characteristics; for example when you report number of employees by cost center, you would create a exception aggregation on “Last value”.
