 Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/12/2019(UTC)
Posts: 41
|
Hi
Can I refer to a comparison in a calculation?
I have a comparison called
"Hour"
having 3 elements called
"Direct"
"Indirect"
"Total"
Can I then do something like this:
if
@[Hour].[Direct] ..... then
BR
Lotte
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 508
|
Hi Lotte,
Yes. Except that it should probably just be sum(@"[Direct]", 0, m1).
And here I am assuming that you just have three columns in your crosstab: Direct, Indirect and Total. You cannot refer to the comparison title itself.
BR / Ole |
Ole Dyring |
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/12/2019(UTC)
Posts: 41
|
Hi Ole Unfortunately it did not solve my problem. Here is my example: Is coming up... I hope ;-) ![Refering to a comparison](//<a href="http://www.freeimagehosting.net/commercial-photography/"><img src="https://i.imgur.com/Jo9YC3n.jpg" alt="Commercial Photography"></a> "Refering to a comparison") BR Lotte Edited by user Thursday, May 9, 2019 10:23:09 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
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.