en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Lotte Bjørn Jensen  
#1 Posted : Tuesday, December 18, 2012 3:00:52 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi

How do I reference the columns underneath "Kasselinie"?

UserPostedImage

I've tried with something like:

if allcount(d1:0, d1, m1) = allcount(d1:@"[Kasselinie]", d1, m1)

But it doesn't work.

Lotte :-)

Best regards

Lotte Bjørn
Niels Thomsen  
#2 Posted : Tuesday, December 18, 2012 3:17:04 PM(UTC)
Niels Thomsen
Rank: Advanced Member

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

Hi Lotte

I'm not quite sure what you want done but to adress one of your columns underneath "Kasselinie" you could e.g. write:
sum(@"[Kasselinie].[2012].[Uge 1]",d1,m1).

The way I read your formula though seems more like you want to find out if there is only "Kasselinie" members and no "Ikke kasselinie"...?
Hope it makes sense.

Best Regards
Niels Thomsen

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


Lotte Bjørn Jensen  
#3 Posted : Tuesday, December 18, 2012 3:37:29 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi

Actually, I want to count how many columns underneath "Kasselinie", that are not empty.

When I do this: count(all, 0, m1), I get both "Ikke kasselinie" and "Kasselinie".
So what do I write instead of all?

Lotte :-)

Best regards

Lotte Bjørn
Páll Bjarkason  
#4 Posted : Wednesday, December 19, 2012 11:22:39 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 154

Hi Lotte

You are using a custom hierarchy hence you should use the following syntax (;) to reference the columns:

count(d-1:@"[Kasselinie]";"[2012].[Uge 1]", d1, m1)

Counting from the right until the column Uge 1 in 2012 in Kasselinie should give you the number of columns for Kasselinie in 2012.

Edited by user Tuesday, May 28, 2013 11:56:22 PM(UTC)  | Reason: ;

Best regards

Páll, CTS
Lotte Bjørn Jensen  
#5 Posted : Wednesday, December 19, 2012 4:45:15 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi Páll

It works, thank you.;-)

Lotte :-)

Best regards

Lotte Bjørn
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