
1. Re: Ratios and Aggregates
Shinichiro Murakami Feb 15, 2016 9:27 PM (in response to Gowtham Chandran)Yes, it's related to the level of aggregations.
[Calculation1]
sum([Profit])/sum([Sales])
[Sales Percentage]
sum([Sales])/[Total Sales]*100
/// 10 / 100 : 20 / 40
/// (10+20) / (100+40) [sum([Profit])/sum([Sales])]
is different from (10/100) + (20/40) [sum([Profit]/[Sales])]
Thanks,
Shin

2. Re: Ratios and Aggregates
Gowtham Chandran Feb 15, 2016 10:11 PM (in response to Shinichiro Murakami)Hi Shin, thanks for your reply.
The first part worked fine. The sales percentage calculation gives wrong values
[Sales Percentage]
sum([Sales])/[Total Sales]*100
The [TotalSales] is a calculated field with calculation sum([sales]) in it. So all the fields show 100 with the sales percentage calculation above.

3. Re: Ratios and Aggregates
Shinichiro Murakami Feb 15, 2016 10:27 PM (in response to Gowtham Chandran)Gowtham,
Put calculated field as below.
[Sales Percentage] // Overview: Level of Detail Expressions
sum([Sales])/attr({fixed :[Total Sales]})*100
Thanks,
Shin

Sample (4)rep_9.1.twbx 1.2 MB


4. Re: Ratios and Aggregates
Gowtham Chandran Feb 15, 2016 10:57 PM (in response to Shinichiro Murakami)Thank you this is what I was looking for. Should make myself comfortable with the LOD calculations..!!

5. Re: Ratios and Aggregates
Shinichiro Murakami Feb 15, 2016 11:01 PM (in response to Gowtham Chandran)It seems something difficult at the first impression, but soon becomes very useful, I can bet .
Thanks,
Shin