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 : Thursday, March 21, 2013 12:35:26 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

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

Hi

How do I count the cells where amount > 0? Right now I'm counting all cells. :-(

UserPostedImage

Regards
Lotte :-)
Best regards

Lotte Bjørn
Niels Thomsen  
#2 Posted : Thursday, March 21, 2013 10:04:23 PM(UTC)
Niels Thomsen
Rank: Advanced Member

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

Hi Lotte

I think you are going to have to make an intermediate calculation setting a flag if a cell contains a value > 0.
It might be something like: if sum(d1,0,m1) > 0 then 1 else 0

Then you sum up this calculated column with a total - maybe like this: sum(c1,all,m1)

Hope it makes sense.
Hope it makes sense.

Best Regards
Niels Thomsen

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


Lotte Bjørn Jensen  
#3 Posted : Friday, March 22, 2013 10:42:56 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

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

Hi Niels

Ok, I was hoping for a calculation, I didn't know of. :-)

Regards
Lotte
Best regards

Lotte Bjørn
Lotte Bjørn Jensen  
#4 Posted : Friday, March 22, 2013 11:14:04 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

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

Hi again

How do I then move the sum of flag beneath the sum of amount.

UserPostedImage

Regards
Lotte :-)

Best regards

Lotte Bjørn
Ragnar Már Magnússon  
#5 Posted : Saturday, March 23, 2013 10:57:13 PM(UTC)
Ragnar Már Magnússon
Rank: Newbie

Groups: extranet\Forum
Joined: 10/15/2012(UTC)
Posts: 1

You should just make a calculation point to the Flag measure

sum(0, all, m2)

-RAZ-
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