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, May 28, 2015 8:49:06 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

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

Hi

Is there a way of navigating in row-calculation like this:

if column = 1 then .. a calculation
else
if column = 2 then .. another calculation
..
..
..

I think I've seen it in this forum, but I can't find it :-(

Regards
Lotte

Best regards

Lotte Bjørn
Niels Thomsen  
#2 Posted : Thursday, May 28, 2015 9:26:05 AM(UTC)
Niels Thomsen
Rank: Advanced Member

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

Hi Lotte

To make a calculated row that identifies which numbered column currently is being evaluated you could write syntax like:
if count(d1:0,d1,m1)= 1 then "do something" else
if count(d1:0,d1,m1) = 2 then "do something" else "do something else"


That would count from left to right and do the calculation depending on which numbered column is currently being evaluated.



Hope it makes sense.

Best Regards
Niels Thomsen

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


Lotte Bjørn Jensen  
#3 Posted : Thursday, May 28, 2015 9:42:49 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

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

Thanks, Niels - just what I needed ;-)
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