en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Georgios Lamprinoudakis  
#1 Posted : Thursday, June 16, 2016 9:53:50 AM(UTC)
Georgios Lamprinoudakis
Rank: Newbie

Groups: extranet\Webinar
Joined: 6/4/2013(UTC)
Posts: 3

Hi,
I am facing a difficulty in a calculation.
I have created a calculation as a row that divides 2 dimension lines that gives me the % discount (sum(0,d4,0)/sum(0,d2,0)).
I also have the variance (A vs LY) as a column (sum(c1,0,m1)-sum(c2,0,m1))/sum(c2,0,m1).
The problem is that in the intersection (Red marked cell) I want the syntax of the column calculation and not of the row.
How can I do this
Calculation Explanation


Thank you
Georgios

Edited by user Thursday, June 16, 2016 10:06:20 AM(UTC)  | Reason: Not specified

Páll Bjarkason  
#2 Posted : Friday, June 17, 2016 4:35:41 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Webinar
Joined: 1/13/2012(UTC)
Posts: 164

Hi Georgios

Check the links out and please be aware to implement the intersection from the correct calculation.
Corresponding to whether you want the row or column value in the intersection.

https://www.targit.com/e...posts&t=555#post1558

https://www.targit.com/e...posts&t=439#post1200
Best regards

Páll, CTS
Georgios Lamprinoudakis  
#3 Posted : Tuesday, June 28, 2016 11:05:41 AM(UTC)
Georgios Lamprinoudakis
Rank: Newbie

Groups: extranet\Webinar
Joined: 6/4/2013(UTC)
Posts: 3

Hi,
It worked but I had to reference the measure columns sum(d-1,0,m1) which were hidden since the calculation columns that I had visible (sum(c1,0,m1)) didn't have the option calculate in intersection.

Thank you
Georgios
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error