en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Lasse Agerlund Jensen  
#1 Posted : Monday, December 3, 2012 3:30:09 PM(UTC)
Lasse Agerlund Jensen
Rank: Member

Groups: extranet\Forum
Joined: 11/11/2012(UTC)
Posts: 6

I have some problems in concern to calculate fields for comparisions. As you can see below isn't it possible to subtract Pulsechurn from Pulsintake for the three vertical calculations in the bottom on the left hand side. Is it somehow possible to do it in another way, than using the advanced calculations i have done here.

UserPostedImage

/Lasse
Niels Thomsen  
#2 Posted : Tuesday, December 4, 2012 3:03:13 PM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 105

Hi

Not knowing your data I'm not quite sure what needs to be calculated?
Is it a column / multiple columns where you subtract pulsechurn from pulseintake?
Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


Lasse Agerlund Jensen  
#3 Posted : Wednesday, December 5, 2012 9:53:16 AM(UTC)
Lasse Agerlund Jensen
Rank: Member

Groups: extranet\Forum
Joined: 11/11/2012(UTC)
Posts: 6

Hi,

I would like to calculate the nettointake, and yes therefore pulsechurn subtracted from pulseintake. Its possible to do it for "two days ago", but not for "last 4 weeks ave." , "last 12 weeks ave." and "last year ave.". "Two days ago" is and comparision, whereas the other 3 are the average of the 3 comparisions: last 4 weeks, last 12 weeks and last year. and therefore calculations based on comparions..
Dont know if its help for the understanding :)

/Lasse
Niels Thomsen  
#4 Posted : Thursday, December 6, 2012 10:00:46 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 105

Ok thanks Lasse - I think I got it now :-)

I tried to "fake" your scenario in demodata:
UserPostedImage

If I understand you correctly the missing 3 cells is the problem.
This is referred to as calculating in the intersection.

By reopening your average calculations in the caluculations tab you get to choose calculate in intersection.
Now you just need to set a checkmark saying that you want to calculate Pulse intake - pulse churn in the intersection.
This has to be done for all your 3 average caluculations.

Hope I understood your problem and that the solution is understandable as well :-))
Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


Lasse Agerlund Jensen  
#5 Posted : Thursday, December 6, 2012 4:10:03 PM(UTC)
Lasse Agerlund Jensen
Rank: Member

Groups: extranet\Forum
Joined: 11/11/2012(UTC)
Posts: 6

Hi Niels,

Thats was what i needed to do - thanks:)

/Lasse
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