en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Heidi Frederiksen  
#1 Posted : Thursday, October 17, 2013 2:47:56 PM(UTC)
Heidi Frederiksen
Rank: Member

Groups: extranet\Customer
Joined: 4/29/2011(UTC)
Posts: 5

Hi

I have hidden some rows in a cross table with 4 measures. I wish to calculate a new total line including new totals for all 4 measures.
Which syntax should I use?


Also I can have challenges with calculated columns which are set to fixed values depending of the outcome of if-sentences. (let say 1 for true, 0 for false)
When I use such a sentence the total is 1 instead of a sum of the entire column. How can I calculate a sum of such a calculated column?



Regards
Heidi Frederiksen, KOMPAN
Niels Thomsen  
#2 Posted : Sunday, October 20, 2013 10:59:49 AM(UTC)
Niels Thomsen
Rank: Advanced Member

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

Hi Heidi

A total of rows including all measures and excluding hidden rows could be sum(0,all(v),0)
This means sum of the current column - all the visible rows - summing up the current measure.

On your second question I'm not quite sure what you want to accomplish, but if it's ok to sum up the "flags" 0 or 1, it's not different than summing up any other values - you could e.g. use the syntax described above.
If I'm missing something here, could you please elaborate on what you want to sum up?

Hope it makes sense.

Edited by user Sunday, October 20, 2013 11:00:26 AM(UTC)  | Reason: Not specified

Hope it makes sense.

Best Regards
Niels Thomsen

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


Heidi Frederiksen  
#3 Posted : Monday, October 21, 2013 10:04:10 AM(UTC)
Heidi Frederiksen
Rank: Member

Groups: extranet\Customer
Joined: 4/29/2011(UTC)
Posts: 5

Thanks a lot...it worked perfektly :-)

Regards
Heidi Frederiksen
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