Locking / Freezing an expressions.

[#1]

Hello,

Im trying to create a table with 2 expressions. How ever i want 1 of those expersions to not change when i select different

dates. However the other should change. How can i lock 1 expression to not change with my current selection?

as you can see on the picture. When i select this month by expamle the first Realisatie should change but the second should stay @ 77,38%.

Any help?

Thanks you Luuk

[martin59]

Hi,

You have to use Set Analysis like this exemple :

avg({1} Realisatie)

[#3]

Hey martin thanks for your quick responce.

How ever im scared i dont fully understand what your saying.

could you be a bit more specific?

[srinivasa1]

pls write set analysis like this

sum

({1} Realistie)

[srinivasa1]

Hi

U can use set anaylysis like bellow for your experssion.

sum

({1} Sales) }

[#6]

Hey thanks for your quick responce,

this doesnt seem to work for me.

When i create it it looks like this.

sum

({1} $(vBezettingsgraad))

You think its bugs cause i use a var?

[martin59]

What is your expression for Realisatie ?

[#8]

It is a quite long var.

 (SUM(IF(Bewerkingen.CODE > 1000, ProjectTime.TotaalUren))
 + Count(Distinct IF(Bewerkingen.CODE = 1000 ,Date))) /
 ( SUM(IF(Bewerkingen.CODE <> 0002 AND Bewerkingen.CODE <> 0012 AND Bewerkingen.CODE <> 0017 AND Bewerkingen.CODE <> 0018 AND Bewerkingen.CODE <> 0019 AND Bewerkingen.CODE <>
 0072 AND Bewerkingen.CODE <> 1000, ProjectTime.TotaalUren )) + Count(Distinct IF(Bewerkingen.CODE = 1000 ,Date)))

[martin59 · Accepted solution]

You can try this :

(sum({1<Bewerkingen.CODE={">1000"}>} ProjectTime.TotaalUren) +
 Count( {1<Bewerkingen.CODE={1000}>} Distinct Date)) /
(Sum({1<Bewerkingen.CODE-={0002,0012,0017,0018,0019,0072,1000}>} ProjectTime.TotaalUren)
+ Count({1<Bewerkingen.CODE={1000}>} Distinct Date))

<div></div>