Calculate Before Aggregation in calculate measure ?

[pavneet_rana]

Hi to all,

What is use for Calculate Before Aggregation in calculate measure.

what happen if i

1. If i check it

or

2. if i don't check it.

Regards

Pavneet Rana

[rindia · Accepted solution]

Hi Pavneet,

As per the Developer guide SPS7 (page 231):

If you select Calculate Before Aggregation, the calculation happens as per the expression specified and then the results are aggregated as SUM, MIN, MAX or COUNT. If Calculate Before Aggregation is not selected, the data is not aggregated but it gets calculated as per calculation expression (formula), and the aggregation is shown as FORMULA. If the aggregation is not set, then it will be considered as an attribute. You should selecting Calculate Before Aggregation only when required as it may decrease the performance.

For more details, please refer to documentation.

Regards

Raj

[former_member182302]

Hi Paveneet,

Adding to Raj's comments:

If you have a formula for a measure like below:

Measure 1: order qty * no .of lines

and you wanted to apply aggregation type: SUM

1. If u check it

sum(order qty * no. of lines )

2. if u don't check it.

sum(sum(order qty) * sum (no of lines))

Regards,

Krishna Tangudu